SQL-exercise icon indicating copy to clipboard operation
SQL-exercise copied to clipboard

Practice with "Real" SQL Problems

Results 8 SQL-exercise issues
Sort by recently updated
recently updated
newest added

I have a better solution for Question 1.16 in SQL_exercise_01 which can solve the query in just 2 lines. **My solution:** select b.name, a.price, a.name from products a join manufacturers...

![image](https://user-images.githubusercontent.com/8358046/57512391-117bbf80-733e-11e9-8388-44fe39503a00.png) ![image](https://user-images.githubusercontent.com/8358046/57512405-1a6c9100-733e-11e9-9db3-b08b9286515a.png) The correct answer is ![image](https://user-images.githubusercontent.com/8358046/57512472-5142a700-733e-11e9-9e0f-ecde104e8db7.png) ![image](https://user-images.githubusercontent.com/8358046/57512478-56075b00-733e-11e9-867c-c2989c611bb9.png)

All build_schema files now have a 'CREATE DATABASE' line to create a new database for questions, and a "USE

Hi, These are way helpful exercises. Thank you so much. Can you please upload the solutions for Exercise 8. I couldn't find one ! Thanks.

3_questions.sql contained prompts with improperly formatted comments. This resulted in comments being interpreted as queries. This pull request adds a necessary space between the comment delimiter and the comment in...