Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 JacksonStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started