{"repo":"maf345/sql-hands-on","free":true,"listed":false,"github":"https://github.com/maf345/sql-hands-on","clone":"git clone https://github.com/maf345/sql-hands-on.git","description":"This repository contains SQL queries from various popular online learning resources e.g. Vertabelo Academy, SQLZoo etc.","language":"SQL","stars":50,"topics":["sql","sql-aggregation","sql-join","mysql","academy","groupby","having","database","step-by-step","beginners-guide"],"license":null,"category":"databases-storage","readme_excerpt":"Welcome to this SQL Repository Repository Description: This repository contains SQL queries from various popular online learning resources e.g. SQLZoo , Vertabelo Academy etc. ### SQL-Zoo: Topics # Total Problem # of Solved :--- :----: :---: 0 SELECT basics 03 03 1 SELECT name 15 15 2 SELECT from World 13 13 3 SELECT from Nobel 14 14 4 SELECT within SELECT 10 10 5 SUM and COUNT 08 08 6 JOIN 13 13 7 More JOIN operations 15 15 8 Using Null 10 10 8+ Numeric Examples 08 08 9 Self join 10 09 ### Vertabelo Academy: Topics # Total Problem (Free) # of Solved :--- :----: :---: 1 Select From Table Section 06 06 2 Aggregation and grouping 08 08 3 SQL Join Types 16 16 #### More Details (Questions & Solutions) of all Sections: SQL-Zoo - 0 SELECT basics section : Problem Statement + MySQL Solution :-------------: Introducing the world table of countries Scandinavia Just the right size 1 SELECT name section : Problem Statement + MySQL Solution :-------------: Problem 1 Problem 2 Problem 3 Problem 4 Problem 5 Problem 6 Problem 7 Problem 8 Problem 9 Problem 10 Problem 11 Problem 12 Problem 13 Problem 14 Problem 15 2 Select from world section : Problem Statement + MySQL Solution :-------------: Introduction Large Countries Per Capita GDP South America in Millions France, Germany, Italy United Two ways to be big One or the other (but not both).sql) Rounding Trillion dollar economies Name and capital have the same length Matching name and capital All the vowels 3 SELECT from Nobel section : Prob","default_branch":null,"files":null,"tree":[],"storefront":"/r/maf345","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/maf345/sql-hands-on/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}