1-Draw the ER diagram and than write DDL of Pharmacy Management System. 2- Name Suld 1 2 3 Saad Assad Amir Saira Sara City Lahore Multan Karachi Lahore Quetta 4 5 Count the students who belong to Lahore or Karachi or Quetta. Show the name of student whose second last letter is 'p' 3-Employee_Salary Employee_ID 1 1 2 3 4 4 Name Amir Amir Assad Saad Umar Umar Salary 1200 1400 1000 1900 3000 2000 i-Write a query to show the total salary of only those employees whose total salary greater than 2000 and whose name starts with 'a'. 4-Write any join query example from Pharmacy Management System which you make in question 1