CUST_ID | CUST_NAME | ANNUAL_REVENUE | CUST_TYPE |
100 | Revathi | 500000 | manufacturer |
101 | Richa | 1800000 | wholesaler |
102 | Rishi | 1000000 | retailer |
103 | Rajesh | 4000000 | wholesaler |
104 | Kalyan | 24800000 | wholesaler |
Data for TRUCK table
TRUCK_NO | DRIVER_NAME |
100 | Jensen |
101 | Sasi |
102 | Jake Stinson |
103 | Alex |
Data for CITY table
CITY_NAME | POPULATION |
London | 100000000 |
Paris | 120000000 |
Rome | 200000000 |
Panama City | 1230000000 |
San Francisco | 20000000 |
Data for SHIPMENT table
SHIPMENT_NO | CUST_ID | WEIGHT | TRUCK_NO | DESTINATION |
100 | 101 | 500 | 101 | Rome |
101 | 101 | 100 | 102 | London |
102 | 103 | 300 | 101 | London |
103 | 103 | 10 | 101 | Paris |
104 | 101 | 20 | 103 | Paris |
105 | 101 | 200 | 101 | San Francisco |
106 | 100 | 50 | 101 | Rome |
107 | 102 | 500 | 101 | Rome |
108 | 101 | 50 | 102 | San Francisco |
109 | 101 | 25 | 100 | Paris |
110 | 101 | 25 | 101 | Panama City |