DataDesk
SQL CREATE TABLE & data types — practice questions · DataDesk
DataDesk
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
CREATE TABLE & data types
Design tables with the right columns and types.
Your progress
0
/ 40
Start the first question
All levels
Basic (27)
Intermediate (8)
Advanced (5)
All
To do
Solved
1
Your first table
Basic
2
Products with prices
Basic
3
Student records
Basic
4
Events with a timestamp
Basic
5
Library books
Basic
6
Column order matters
Basic
7
Shift timings
Basic
8
Employees table
Basic
9
Course catalogue
Basic
10
Hospital patients
Basic
11
Movie ratings
Basic
12
Bank accounts
Basic
13
Daily attendance
Basic
14
Train timetable
Basic
15
App logs
Basic
16
Restaurants
Basic
17
Small numbers
Basic
18
Create and fill
Basic
19
Electronics only
Basic
20
Mumbai customers
Basic
21
Wallet transactions
Basic
22
Delivery partners
Basic
23
Phone numbers are text
Basic
24
Hotel rooms
Basic
25
Flights
Basic
26
Gym members
Basic
27
Two tables
Basic
28
Pick the right types
Intermediate
29
Only if it doesn't exist
Intermediate
30
Replace an old table
Intermediate
31
Quoted column names
Intermediate
32
Copy a table's structure (no rows)
Intermediate
33
Create a table from a query
Intermediate
34
Summary table
Intermediate
35
Two related tables
Intermediate
36
Computed (generated) column
Advanced
37
Directory from a join
Advanced
38
Top customers snapshot
Advanced
39
Backup before a risky change
Interview
Advanced
40
Lookup table with values
Advanced