Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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;
A: TAVAN = Part B: Apply the following Query and provide appropriate answer (Total Marks=5) 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 Nizwa 3@xyz.com 1000 4 Ahmed IBRA 4@xyz.com 900 5 Abdullah Muscat5@xyz.com 400 Previous page Next page SQL Activity for section 2 and 80 Jump to
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