Question

please help its urgent pls

Write the answers based on the following table:
Table: Manger

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

Answer 1

pls write question properly

Answer 2

pls write down question properly.