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  
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 + q]: 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




Welcome!

Sql-practice values your privacy

We and our vendors (1417) store and/or access information on a device, such as
cookies and process personal data, such as unique identifiers to personalize
content and ads, provide social media features, analyze our traffic, and develop
and improve products.

We and our vendors may use precise geolocation data and identification through
device scanning with your permission. You may click to consent to our and our
partners’ processing as described above. Alternatively, you may access more
detailed information and change your preferences before granting or refusing
consent.

Please note that some processing of your personal data may not require your
consent, but you have a right to object to such processing. Your preferences
will apply to this website only. You can change your preferences at any time by
returning to this site. Scope of consent is service-specific.

Manage settings
Consent to All
Powered by