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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!