Food Delivery Website SQL Analysis, PostgreSQL - rextester

Run Code | API | Code Wall | Misc | Feedback | Login | Theme | Privacy | Patreon

Food Delivery Website SQL Analysis

Language: Layout:


absolute service time: 0,72 sec

edit mode | history | discussion

  
merchant_id
merchant_name
merchant_state
merchant_city

1
187432
Joes Diner
ID
Boise

2
192643
Slice of Pie
CA
San Francisco

3
173444
Toms Cake
NY
Brooklyn


  
order_id
order_date
merchant_id

1
187432
10.12.2017 00:00:00
187432

2
192643
03.04.2018 00:00:00
192643

3
173444
10.11.2018 00:00:00
786512


  
order_id
order_date
merchant_id
merchant_id
merchant_name

1
187432
10.12.2017 00:00:00
187432
187432
Joes Diner

2
192643
03.04.2018 00:00:00
192643
192643
Slice of Pie

3
173444
10.11.2018 00:00:00
786512
786512
NULL

λ

                                      .NET NoSQL database for rapid development