sqlteaching | SQL Teaching is an interactive tutorial for learning SQL | SQL Database library
kandi X-RAY | sqlteaching Summary
kandi X-RAY | sqlteaching Summary
SQL Teaching is an interactive tutorial for learning SQL. It is available on SQL Teaching is MIT licensed - see the LICENSE file for more details. It’s easy to contribute levels to SQL Teaching. The sqlteaching.js file contains a variable called levels. This variable has the prompts and answers for each level. It is an array of dictionaries (the order of the levels). In each dictionary, there are the following keys: - name: name shown on web page - short_name: identifier added to the URL - database_type: is passed into the load_database function, in order to determine the tables loaded - answer: the query that the user writes must return data that matches this value - prompt: what is shown to the user in that web page. And the following keys are optional: - required: Extra validation in the form of case-insensitive required strings - custom_error_message: If the validation fails, show this error message to the user.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of sqlteaching
sqlteaching Key Features
sqlteaching Examples and Code Snippets
Community Discussions
Trending Discussions on sqlteaching
QUESTION
Disclaimer: it is probably a trivial mistake.
To solve the query at this link:
Can you return the results with a column named sound that returns "talk" for humans, "bark" for dogs, and "meow" for cats?
I need to write a CASE
with multiple possibilities.
What is wrong with the following syntax?
...ANSWER
Answered 2018-Oct-07 at 11:33Well, you are missing a comma after *
:
QUESTION
I solved the query at this link
Can you return a list of characters and TV shows that are not named "Willow Rosenberg" and not in the show "How I Met Your Mother"?
with the following code:
...ANSWER
Answered 2018-Oct-07 at 09:07You can using subqueries
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install sqlteaching
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page