COLUMN NAME DATA TYPE NULLABLE DATA DEFAULT COLUMN ID Hiredate date no (null) 9 professorid NUMBER(8,0) no (null) 1 phone VARCHAR2(10 BYTE) yes (null) 8 state VARCHAR2(2 BYTE) no (null) 6 firstname VARCHAR2(25 BYTE) no (null) 2 lastname VARCHAR2(25 BYTE) no (null) 3 city VARCHAR2(25 BYTE) no (null) 5 streetaddress VARCHAR2(40 BYTE) no (null) 4 zip VARCHAR2(9 BYTE) yes (null) 7 7 Show the city, state, number of professors and the earliest hire date per city and state for those cities and states that have more than 20 professors Arrange the list by the earliest hire date then number of professors Name columns correctly and show dates and time as appears in the results

The Answer is in the image, click to view ...

Question: COLUMN NAME DATA TYPE NULLABLE DATA DEFAULT COLUMN ID Hiredate date no (null) 9 professorid NUMBER(8,0) no (null) 1 phone VARCHAR2(10 BYTE) yes (null) 8

COLUMN NAME DATA TYPE NULLABLE DATA DEFAULT COLUMN ID Hiredate date

COLUMN NAME	DATA TYPE	NULLABLE	DATA DEFAULT	COLUMN ID
Hiredate	date	no	(null)	9
professorid	NUMBER(8,0)	no	(null)	1
phone	VARCHAR2(10 BYTE)	yes	(null)	8
state	VARCHAR2(2 BYTE)	no	(null)	6
firstname	VARCHAR2(25 BYTE)	no	(null)	2
lastname	VARCHAR2(25 BYTE)	no	(null)	3
city	VARCHAR2(25 BYTE)	no	(null)	5
streetaddress	VARCHAR2(40 BYTE)	no	(null)	4
zip	VARCHAR2(9 BYTE)	yes	(null)	7

7. Show the city, state, number of professors and the earliest hire date per city and state for those cities and states that have more than 20 professors. Arrange the list by the earliest hire date then number of professors. Name columns correctly and show dates and time as appears in the results

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Unit 6 Lab - SQL statements - Need help on these CIS 338: SQL/Oracle Learning Unit 6: Lab Activity Lab Activity Complete the following SQL exercises using the JustLee Books database. Launch Oracle...

Unit 3 Assignment - SQL statements - Please be aware that I am using APEX.ORACLE.com and the SQL command statement must run successfully without errors. 1. Which orders shipped after April 1, 2009?...

Create a script file that performs the following in SQL developer. Insert a statement to drop the "CustomerView" Insert a statement to create an updatable view, "CustomerView" based on the "Customer"...

Write a procedure that insert paid invoices from the "paid_invoices" table into the "invoice_archive" table. Only those paid invoices that are older than or equal to 31-05-2014 should be transferred....

USING SQL Write a procedure that automatically insert the paid invoices from invoices table into the paid_invoices table. Inserted Invoices should be unique ( no duplicate invoices). Write a function...

Write SQL query to create a view payed_vendors, containing the vendor name, the count of invoices, the sum of the total invoices, and the sum of the total payments. For those that have 2 or more...

Using the PETS table, write sql queries that will do the following: 1.Display the average weight of animals grouped by pet type. 2.Display a count of how many animals there are of each color....

CIS 4338 Hello I need help in how to create a self join this are the directions: "Self-Join. Write a query that is a self-join that, when executed, returns a list of employees with the name of their...

Use www.imdb.com (Links to an external site.) to find at least 6 titles for your movies table. Create at least 6 fake records for your customers table. You will add data to the rest of the tables...

Paragraph scale Styles Default value Table name Client Column name Data Type C Number Numeric C Name Variable character C Address Variable character C City Variable character C State Fixed character...

Question 1 Discuss the implications of credit card fraud? Question 2 where does credit card fraud generally happening? Question 3 Explain any 2 or 3 types of procurement scheme? Question 4 what are...

A wave pulse on a string has the dimensions showninFig.15.31 at t = 0. The wave speed is 40 cm/s. (a) If point o is a fixed end, draw the total wave on the string at t = 15 ms, 20ms, 25 ms, 30 ms, 35...

i need help on how to get max profit and the steps to get there

[Review Topics Reference Use the References to access important values if needed for this question. When the following molecular equation is balanced using the smallest possible integer coefficients,...

Suppose government spending increases. Would the effect on aggregate demand be larger if the Federal Reserve took no action in response or if the Fed were committed to maintaining a fixed interest...

Suppose that people suddenly wanted to hold more money balances. a. What would be the effect of this change on the economy if the Federal Reserve followed a rule of increasing the money supply by 3...

Suppose the federal government cuts taxes and increases spending, raising the budget deficit to 12 percent of GDP. If nominal GDP is rising 5 percent per year, are such budget deficits sustainable...