www.sql-practice.com Open in urlscan Pro
2a06:98c1:3120::3  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Run  
Settings
hospital.db northwind.db Right Menu Left Menu
Contact
SQL Database
View Schema
patients


patient_id INT first_name TEXT last_name TEXT gender CHAR(1) birth_date DATE
city TEXT province_id CHAR(2) allergies TEXT height INT weight INT

admissions


patient_id INT admission_date DATE discharge_date DATE diagnosis TEXT
attending_doctor_id INT

doctors


doctor_id INT first_name TEXT last_name TEXT specialty TEXT

province_names


province_id CHAR(2) province_name TEXT

Learning Resources
Query Basics
Select Statement Insert Statement Delete Statement Update Statement Where Clause
Query Filtering
Operators Order By Like In Between Join Union Group By Having Case Distinct
Exists Any, All Ifnull Null Values Aliases
Functions
Aggregate
COUNT AVG SUM MAX MIN
Window
Window Function Basics LAG LEAD FIRST_VALUE LAST_VALUE
String
CONCAT LEN UPPER LOWER
Numeric
RAND ROUND FLOOR CEIL
Math
ABS POWER SQRT
Date
CURRENT_TIMESTAMP YEAR MONTH DAY
Tables
Datatypes Create Table Drop Table Alter Table Constraints Not Null Unique
Primary Key Foreign Key Check Default Auto Increment Index
Ad

14


 
1

SELECT * FROM patients

2

​

3

/*

4

  Start by selecting a question by pressing 'Start' or 'View All Questions'.

5

  Use the resources and information about the database from the left panel to help.

6

  Press the run button to execute the query.

7

  Question is automatically validated every time you execute the query.

8

  Make your output match the expected output.

9

 

10

 

11

  Keybinds:

12

    [ctrl + enter]: Execute the SQL

13

    [ctrl + j]: Auto-format the SQL

14

*/





PRACTICE SQL

Query results are outputted here.
Click the run button to execute the query.

View All Questions
Start
Easy Medium Hard