Lolapolazaoperates three handbag stores located in 3 different states in USA : New York(NY), Chicago and Florida. The company maintains a distributed database across the three locations and supports location transparency. The database fragment in Chicago stores only the sales transactions in Chicago , the database fragment in Florida stores only the sales transactions in Florida while the database fragment in KL stores only the sales transactions in NY. The following tables shows the fragments with sample data in each location. TABLE: CHI_ORDER ORDER_ID DATE TOTAL P01 22-OCT-2020 239.50 P02 23-OCT-2020 69.90 P03 24-OCT-2020 530.10 TABLE: FL_ORDER ORDER_ID DATE TOTAL FL01 22-OCT-2020 100.50 FL02 23-OCT-2020 80.00 FL03 24-OCT-2020 631.50 TABLE: NY_ORDER ORDER_ID DATE TOTAL NY01 22-OCT-2020 44.30 NY02 23-OCT-2020 400.60 NY03 24-OCT-2020 1200.00 As the database administrator of Lolapolaza, the top management has requested you to generate a sales report showing all the transactions from all three stores that are above USD100.00. Write the SQL query to generate the desired report. Duplicate records should be excluded
Lolapolazaoperates three handbag stores located in 3 different states in USA : New York(NY), Chicago and Florida. The company maintains a distributed
TABLE: CHI_ORDER
|
ORDER_ID |
DATE |
TOTAL |
|
P01 |
22-OCT-2020 |
239.50 |
|
P02 |
23-OCT-2020 |
69.90 |
|
P03 |
24-OCT-2020 |
530.10 |
TABLE: FL_ORDER
|
ORDER_ID |
DATE |
TOTAL |
|
FL01 |
22-OCT-2020 |
100.50 |
|
FL02 |
23-OCT-2020 |
80.00 |
|
FL03 |
24-OCT-2020 |
631.50 |
TABLE: NY_ORDER
|
ORDER_ID |
DATE |
TOTAL |
|
NY01 |
22-OCT-2020 |
44.30 |
|
NY02 |
23-OCT-2020 |
400.60 |
|
NY03 |
24-OCT-2020 |
1200.00 |
As the database administrator of Lolapolaza, the top management has requested you to generate a sales report showing all the transactions from all three stores that are above USD100.00. Write the SQL query to generate the desired report. Duplicate records should be excluded
Step by step
Solved in 2 steps
