Question: sql queries for rhese questions above 10 DELETE Step 4 Command A- How many computers have a price more than 1700 CAD? Write a query

sql queries for rhese questions above
10 DELETE Step 4 Command A- How many computers have a price more than 1700 CAD? Write a query to show the number of computers with a price more than 2000 CAD. B-Delete all computers with prices greater than 2000 CAD, and show the remained computers in our table. S Step 5- More Select, Create and Insert command A- We need to see all the computer's information sorted by the price. B- How many rows exits in your table? Find out using a select command (count function). C- Add the second table. Name it customers' with CusID, First Name, last nane, City. D- Add five customers to your table. 0 Step 6- Update A- Add The third table. Name it 'Sales'. The columns are ID. Cusio, ComplD, Date, Quantity. B- Add 10 sales to your table. It is important to use the same ComID and CustD you used in computers and Customers tables. C- Change the the Ram of all Dell computers to 8. D- Change the last customer's last name to Jackson
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
