Use the following query to answer the question below it: SELECT PAT_NAME"Patient" ,PAT_ID "Patient ID" ,PROV NAME "Discharge Provider" ,PROV_NAME "Admitting Provider" ,DEPARTMENT_NAME "Discharge Department" FROM PAT_ENC_HSP INNER JOIN PATIENT ON PAT_ENC_HSP.PAT_ID = PATIENT.PAT_ID INNER JOIN CLARITY DEP ON PAT_ENC_HSP.DEPARTMENT_ID = CLARITY DEP. DEPARTMENT_ID INNER JOIN CLARITY_SER ON PAT_ENC_HSP.ADMISSION_PROV_ID = CLARITY_SER.PROV_ID INNER JOIN CLARITY_SER ON PAT_ENC_HSP.DISCHARGE_PROV_ID = CLARITY_SER.PROV_ID WHERE HOSP_DISCH_TIME IS NOT NULL Which table from this query must be aliased? Select one of the following: A. Patient B. PAT_ENC_HSP C. CLARITY_SER D. CLARITY_DEP

Write an SQL query that will select OrderID and OrderDate from theOrders table and OrderDetailID from the OrderDetails table. The queryshould join on the Orders table using the OrderID attribute.

Which type of join is demonasted by the folloing query? Select from make. model where make modelID to mode ID a) Non-Equlion b) Self Join c) Cross Join d) Equijoin

Create a table in SQL developer and name it as ‘MyCrush’. The table should consists of only three attributes as follows: Crush_ID which will be the primary key with the number length of .Crush_Name with the maximum character length of 30.Crush_Description with the maximum character length of 10.Insert exactly three records with the above given attributes. Crush_ID values should be 1, 2 and 3 for the three records. Crush_Description should be ‘Present’ for record 1, ‘Past’ for record 2 and ‘Childhood’ for record 3. If you don’t have any crush from your childhood to present, you can insert some random names. Hmm.. Seems Interesting!! It’s time to implement your programming skills using PL/SQL stored procedures and functions. Create another table called ‘MyDetails’ and should contain exactly four attributes as below: Student_ID,Student_Name ,Student_Term ,Student_GPA If you are not a Master’s student, let’s assume you are a student pursuing masters and taking four semesters or terms.…