Search results
Learn SQL using: SQL Server, Oracle, MySQL, DB2, and PostgreSQL. This repo contains the answers from the SQLzoo web site.
Harder Questions: SELECT name, CASE WHEN continent ='Oceania' THEN 'Australasia'. ELSE continent END. FROM world. WHERE name LIKE 'N%'. SELECT name, CASE WHEN continent ='Europe' or continent ='Asia' THEN 'Eurasia'. WHEN continent in ('North America', 'South America', 'Caribbean') THEN 'America'.
Assessments: More involved examples for confident users. Each assessment includes 15 questions graded easy, medium and hard.
My solutions to all of the main 9 and 4 additional topics posted on the sqlzoo.net tutorial. All answers were 💯 percent correct and generated correct feedback on the day they were uploaded. Feel free to use and if u have any suggestions don't hesitate to contact me . 😃
Find solutions to some of SQLZOO tutorials and assessments with tables from 2021. Browse the code and explanations for self join, helpdesk, adventure works, university, musicians and more.
1 gru 2020 · The author shares their solutions to the basic questions of sqlzoo.net, a website for learning SQL. The post contains SQL queries for selecting data from different tables, using functions, operators, and joins.
21 lip 2020 · SQL Zoo Queries. These answers to the SQLZoo queries give many examples of using select statements. seaquell: Tame the stormy seas of SQL with sea-quell, another DSL for generating SQL statements Documentation for seaquell v0.5.2 on cljdoc.
