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

Form analysis
0 forms found in the DOM

Text Content

Run   Support
Settings
Right Menu Left Menu
SQL Database
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

xxxxxxxxxx



 
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

  If you can't solve a question you can press 'Skip Question' to view the solution.

11

 

12

  Keybinds:

13

    [ctrl + enter]: Execute the SQL

14

    [ctrl + q]: Auto-format the SQL

15

*/





PRACTICE SQL

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

View All Questions
Start
Easy Medium Hard