In: Computer Science
Question 1. Write the statement to increase the
invoice_total by 25% using the INVOICES
table for all vendors whose vendor_id is less than 100.
Question 2. Write the statement to answer the
following question: What is the total of the
invoice_total amounts after the update. I need your statement and
the result stated
here.
Question 3. Write the statements to list the
customer ID and Order ID from the ORDERS
table for all orders with order id greater than 700.
Question 4. Write the statement to delete the order with order ID = 1021.
Question 11. Write the statement to show the
total number of rows in the Orders table. Also,
write the number of rows returned from the query.
Question 1. Write the statement to increase the
invoice_total by 25% using the INVOICES
table for all vendors whose vendor_id is less than 100.
select vendor_id, invoice_total*0.25 from INVOICES where vendor_id < 100;
Question 2. Write the statement to answer the
following question: What is the total of the
invoice_total amounts after the update. I need your statement and
the result stated
here.
appropriate information not provided.
Question 3. Write the statements to list the
customer ID and Order ID from the ORDERS
table for all orders with order id greater than 700.
select customer_id, order_id from ORDERS where order_id >700;
Question 4. Write the statement to delete the order with order ID = 1021.
delete from ORDERS where order_id = 1021;
Question 11. Write the statement to show the
total number of rows in the Orders table. Also,
write the number of rows returned from the query.
select count(*) as total_number_of_rows from ORDERS;
note: the relational schema and records are not provided and hence the results cannot be shown. The answers are given based on the information provided. Also, while writing the statements keep in mind the table names and column names are case sensitive. Try these out and if you face any problem, feel free to ask I will be there to help.