Question

Create a table Sales using SQL statement with the following instructions and apply the SQL queries
accordingly. (write all these statements and steps in a word document and upload in the given link)
• Field names : Location
order_id, onder date, quantity, price
• Assign a primary key for a suitable field
Add another field Region to Sales table
Insert 5 records in the table
Sort the table in descending order of price
Write the SQL queries to delete a record from the table
Write the SQL statement to view region, quantity, price, quantity*price from sales table

Answer 1

Answer:

whats this weird very very weird somethings fishy