Specify the following queries in SQL on the database schema listed below. a. Retrieve the names of all senior students majoring in 'CS' (computer science). b. Retrieve the names of all courses taught by Professor King in 2007 and 2008. c. For each section taught by Professor King, retrieve the course number, semester, year, and number of students d. Retrieve the name and transcript of each senior student (Class = 4) majoring in CS. A transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student. who took the section. STUDENT Nane Studert.rumber 17 Clam Maor Brown Cs cs

Specify the following queries in SQL on the database schema listed below. a. Retrieve the names of all senior students majoring in 'CS' (computer science). b. Retrieve the names of all courses taught by Professor King in 2007 and 2008. c. For each section taught by Professor King, retrieve the course number, semester, year, and number of students d. Retrieve the name and transcript of each senior student (Class = 4) majoring in CS. A transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student. who took the section. STUDENT Nane Studert.rumber 17 Clam Maor Brown Cs cs

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

help with sql class 1. Report the names of the professors who work on 'project01'. 2. Report the names of the students who do not have a supervisor.
Please answer all my questions by using sql
Answer these question by using these tables. Please. Create in PL/SQL a stored procedure called 'StudentsActivities' to display the list of students and the activities in which they participated. Create in PL/SQL a stored Function called 'Checkavailability' to check whether 'Salalah Hall' is busy or not in a given date. Create in PL/SQL a stored Procedure called 'CheckavailabilityProc' to call the function 'Checkavailability' and display the appropriate message according to the value returned by the function (If function returns true, the procedure will display 'Salalah Hall is free on date ######' otherwise'Salalah Hall is busy on date ###### '). CREATE TABLE Student (studid Char(9) Primary Key,FirstName Varchar2(50) NOT NULL,LastName Varchar2(50) NOT NULL,Email Varchar2(50) NOT NULL UNIQUE,PhoneNumber Number(8) NOT NULL UNIQUE,GPA Number(1,2) NOT NULL); Insert into Student(studid, FirstName, LastName, Email, PhoneNumber, DateOfBirth, GPA) values…
8. Using today’s date, determine the age (in months) of each book that JustLee sells. Makesure only whole months are displayed; ignore any portions of months. Display the book title,publication date, current date, and age. SQL commands
Write queries in SQL to answer each of the following questions: 1. Find all students in Comp. Sci. dept 2. Find all students with total credits > 100 3. Find all students who took course in Spring 2010 (Remove duplicates please) 4. Find all courses taken by the student whose ID is 76543 and also find his name create table student (ID varchar(5), name varchar(20) not null, dept_name varchar(20), tot_cred numeric(3,0), primary key (ID) ); create table takes (ID varchar(5), course_id varchar(8), sec_id varchar(8), semester varchar(6), year numeric(4,0), grade varchar(2), primary key (ID, course_id, sec_id, semester, year) ); insert into student values ('00128', 'Zhang', 'Comp. Sci.', '102'); insert into student values ('12345', 'Shankar', 'Comp. Sci.', '32'); insert into student values ('19991', 'Brandt', 'History', '80'); insert into student values ('23121', 'Chavez', 'Finance', '110'); insert into student values ('44553', 'Peltier', 'Physics', '56'); insert into student values…
oracle SQL
Answer the following SQL questions using MySQL command language in MySQL Workbench, sakila database environment!
Use SQL Developer.
use sql to answer the following question To perform below tasks, refer to tables in the JustLee Book database. Create a list that display the title of each book and the name and phone number of the contact at the publisher’s office for reordering each book. Which books were written by an author with the Last Name-First Name (BAKER JACK)? Perform the search using author’s last name/first name. Determine which book(s) purchased by customer Steve Schell. Perform the search using the customer name & last name, not the customer number. If he/she has purchased multiple copies of the same book, unduplicated(DISCTINC) the result.
Emp.id Name 001 JACK 002 Omar 003 Madeline 004 Macarthur 005 Rafael Job.id ceo dept.man dir.man sales man sales_man Hire-date Location 22-May-10 new York 160000 23-Jun-10 Los Angeles 5000 24-Jan-11 Washington 7000 25-Dec-12 Philadelphia 4000 26-Jul-12 Boston 4000 Salary
Q11)?,Q12)?,Q13)?
please use sql to answer the following question an erd has been adding to to question question t