Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the following table to answer the query ID Name City Email Salary 1 Fatima Sur 1@xyz.com 1000 2 Mohammed Salalah 2@xyz.com 800 3 Khalid
Use the following table to answer the query
ID | Name | City | | Salary |
1 | Fatima | Sur | 1@xyz.com | 1000 |
2 | Mohammed | Salalah | 2@xyz.com | 800 |
3 | Khalid | Nizwa | 3@xyz.com | 1000 |
4 | Ahmed | IBRA | 4@xyz.com | 900 |
5 | Abdullah | Muscat | 5@xyz.com | 400 |
1-Select name, ID, Address from Customer where not city=IBRA;
2-Select * from Customer where ID Between 1 and 3;
3-Update Customer set City= Muscat where ID= 5;
4-Delete from Customer where name= Ahmed and city=IBRA;
5-Select * from Customer order by Name Desc;
Step 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