d. write a query to retrieve the name of graduate student and student advisor name of all graduate student. professorsProjectsSSN nameage R_specialty rankpnumber namestartingending Date budget ssn_proAlexandra | 30ScienceAssistant ProfessorDateEnglishAssistant Professor9/4/202020/3/2020 20/4/202029/4/20209/4/202020/3/2020 29/5/20202Alex351Analysis_1 1/3/202030013.Lesbon40MathmaticProfessor2Translate4002smithSciencenullCalculation 1/4/2020Analysis_2 1/3/2020algorithm43236003Loai42ComputerProfessor4200153205Work_Indepartmentswork_deptpnumberSsn dnumber time1ssndnumber nameOfficeSsn_pro11New York13:00pmIT13212:30am22ScienceBoston3231:00pm21133EngineeringHealth sciences New YorkBoston3123:00am243411:00am5AccountingChicago1work_projGraduteSSN Gradute_NO pnumber11SSNnameAvg degree agednumber advise221Laila852411.3Ali9022124413|23Ahmed95262515Saminll303121Amany853222.326Andre95335343

The query works for both ms sql server and mysql.

Answered: d. write a query to retrieve the name…

Engineering

Computer Engineering

d. write a query to retrieve the name of graduate student and student advisor name of all graduate student.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Write a query that will display all movies with a return date of March 1, 2018, March 5, 2018, March 15, 2018, March 17, 2018 or March 25, 2018. Note: Do not use the OR operator for this query.
Create a query to show the subject and the quantity of books in each category. Sort the results in ascending order by the number of books, then in ascending order by the subject name.
Write a query to list the author last name, author first name and the book title and cost for each book written by the author “Xia Chiang”. Sort the result by the book title and then the costdescending
Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date.
Write a query to list the book title, checkout date, checkout due date and checkout in date for each book.
Do not use AI.
ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear
From the following query, identify the value of City: INSERT INTO Customers ( CustomerName, ContactName, Address, City, PostalCode, Country) VALUES (‘Cardinal,”Tom B. Erichsen”,”Skagen 21”, “Stavanger,” “4006Norway’);
Please help: Using the following sql file, how would you find List all the rows in which the prescription dates occur on or after November 14. How many doctors provide prescriptions with 30 tablets in total? List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order Find all patients rows whose first names include ‘George’ (Assume case sensitivity). List number of patients that do not have a phone number. Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End; //* Assignment_1 */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR…
3. Run a query that gives the average grade on the final exam for male students and for femalestudents. Round that number to 1 decimal place only.
The following database will be used in this question: SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 SalesRepNo 345 434 654 345 800 100
8) Create a query for displaying list of employees who joined in the second half of year ‘07’;