Question

Write the answers based on the following table:
Table: Manager
Deptno Deptname Name City
S101 Sales Pranjal Sharma Delhi
HR404 HR Preeti Arora Chennai
P204 Purchase Sukhmeen Singh Bangalore
AD990 Admin Sukanya Kumar Mumbai
a. Write a SQL query to change city of AD990 to Pune.
b. Write a query to display all the records of the table in ascending order of Deptname.
c. Add a new record with the following details: (‘S106’, ‘Sales’, “Kritika Tuteja”, “Delhi”).

Answer 1

Answer:

please subscribe my channel is live insaan please