Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Select Healthcare Classification Systems And Databases

Authors: Katherine S. Rowell, Ann Cutrell

1st Edition

0615909760, 978-0615909769

More Books

Students also viewed these Databases questions

Question

2. Identify and choose outcomes to evaluate a training program.

Answered: 1 week ago

Question

6. Conduct a cost-benefit analysis for a training program.

Answered: 1 week ago