Billy, who owns a homemade pasta restaurant, gathers the fol…
Billy, who owns a homemade pasta restaurant, gathers the following information to make a decision on whether to stay open for business or to shut down permanently: Future operating revenues = $20 millionFuture operating costs = $15 millionSunk costs = $10 million Billy should
Read DetailsYou have been asked to create a report that lists all custom…
You have been asked to create a report that lists all customers who have placed orders of at least $2,500. The report’s date should be displayed in the Day, Date Month, Year format (For example, Tuesday, 13 April, 2004 ). Which statement should you issue?
Read DetailsEvaluate this SELECT statement: SELECT p.player_id, m.last_n…
Evaluate this SELECT statement: SELECT p.player_id, m.last_name, m.first_name, t.team_name FROM player p LEFT OUTER JOIN player m ON (p.manager_id = m.player_id) LEFT OUTER JOIN team t ON (p.team_id = t.team_id); Which join is evaluated first?
Read DetailsThe FACULTY table contains these columns:FACULTYID VARCHAR2(…
The FACULTY table contains these columns:FACULTYID VARCHAR2(5) NOT NULL PRIMARY KEYFIRST_NAME VARCHAR2(20)LAST_NAME VARCHAR2(20)ADDRESS VARCHAR2(35)CITY VARCHAR2(15)STATE VARCHAR2(2)ZIP NUMBER(9)TELEPHONE NUMBER(10)STATUS VARCHAR2(2) NOT NULLThe COURSE table contains these columns:COURSEID VARCHAR2(5) NOT NULL PRIMARY KEYSUBJECT VARCHAR2(5)TERM VARCHAR2(6FACULTYID VARCHAR2(5) NOT NULL FOREIGN KEYYou have been asked to compile a report that identifies all adjunct professors who will be teaching classes in the upcoming term. You want to create a view that will simplify the creation of this report. Which CREATE VIEW statements will accomplish this task?
Read Details