Online SQL Editor

Hamburger Icon


Customers [-]

  • customer_id[int]
  • first_name[varchar(100)]
  • last_name[varchar(100)]
  • age[int]
  • country[varchar(100)]

Orders [-]

  • order_id[integer]
  • item[varchar(100)]
  • amount[integer]
  • customer_id[integer]

Shippings [-]

  • shipping_id[integer]
  • status[integer]
  • customer[integer]

Input

Output

first_nameage
John31
Robert22
David22
John25
Betty28

OutputAvailable Tables
first_nameage
John31
Robert22
David22
John25
Betty28

Available Tables

Customers

customer_idfirst_namelast_nameagecountry
1JohnDoe31USA
2RobertLuna22USA
3DavidRobinson22UK
4JohnReinhardt25UK
5BettyDoe28UAE

Orders

order_iditemamountcustomer_id
1Keyboard4004
2Mouse3004
3Monitor120003
4Keyboard4001
5Mousepad2502

Shippings

shipping_idstatuscustomer
1Pending2
2Pending4
3Delivered3
4Pending5
5Delivered1