Customer custid custname annualrevenue custtype address cit...

Customer cust_id cust_name annual_revenue cust_type address city state zip phone Shipment ship_id cust_id weight truck_id driver_id city_id ship_date City city_id city_name state population area Truck truck_id make model_year Driver driver_id first_name last_name address city state zip_code phone

Transcript

00:01 Hello students, here i am going to write a spil query for the given requirement as the first is to list in an alphabetical order the names of the customer with more than the 10 $ millions in the annual income.

00:16 So for that i will write as select select from as i need the customer name select from the customer name from the table customers as where i am providing a specific condition as where the annual revenue needs to be less than 10 $ million.

01:01 Then you need to in an alphabetical order so you will represent with an order by the customer name as in an ascending form.

01:17 The second given is as we need to write the query for give the names and the average monthly revenue of the customers having an annual revenue exceeding of 20 $ million as they name the column with an average monthly revenue.

01:36 So for that i will write an spil query from select select i need the customer name as well as the annual revenue with 12 $ million as the average monthly revenue from the customer table from the customers where we can find as the annual revenue to be less than 20 $ million.

02:48 As for the next query is to retrieve the truck id of the trucks that have carried the small shipments that is weighting the less than 800 pounds without the duplicate.

03:07 So for that i will write an sql query for select select the distinct distinct as from the id trunk id truck id id from the table of called shipments shipments fine shipments.

03:32 Now where we need to apply the condition where the weight is the it must be less than the 800 weight.

03:43 So where the weight is less than the 800 pounds less than the 800 pounds...

Question

Customer cust_id cust_name annual_revenue cust_type address city state zip phone Shipment ship_id cust_id weight truck_id driver_id city_id ship_date City city_id city_name state population area Truck truck_id make model_year Driver driver_id first_name last_name address city state zip_code phone

Please give Ace some feedback