Bhavya_Abhaykumar_Jain_DS632_Homework 2

docx

School

New Jersey Institute Of Technology *

*We aren’t endorsed by this school

Course

632

Subject

Industrial Engineering

Date

Jan 9, 2024

Type

docx

Pages

Uploaded by BaronElectron12949

DS 632, Spring 2023, HOMEWORK 2 NAME: BHAVYA ABHAYKUMAR JAIN EMAIL ID: bj26@njit.edu My Student ID: 31571442

1). Broadband First 10 rows. Output: - 2). Health First 10 rows. Output: -

3) Medium First 10 rows. Output: - Q. Write a SELECT statement that shows the table HEALTH in alphabetical order by state (that means, by the column Geography). Ans. Query: -

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Output: - Q. Write a SELECT statement that shows the table BROADBAND in increasing order by percentage (that means, by the column Estimate). Ans. Query: - Output: -

Q. Perform a JOIN on the three tables so that the result will be a display that shows four columns: STATE (in alphabetical order), MEDIAN, HEALTH, BROADBAND. Ans. Query: - Output: -

Q. Repeat the join and capture the result as a view with the name USDATA. Ans. Query and Output: - Q. Run a SELECT statement against the view USDATA. Ans. Query: - Output: -

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Q2) Write a PL/SQL program using an IMPLICIT cursor that shows rows from USDATA where the median income is above $60,000 AND the percentage of households without health insurance is above 6.5%. Ans. Query: - Output: - Output: -

Q3. Write a PL/SQL program using an IMPLICIT cursor that shows every third row from USDATA, starting with the FIRST row. So you will show the first, fourth, seventh, etc. row. Ans. Query: -

Output: -

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Q4) Write a PL/SQL program that finds the state with the highest median income in USDATA. Ans. Query: -

Output: - Q5. In SQL create a table MAXSTATES with one column for a text string. Ans 5. Query: -

Output: -

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Query: - Output: -

Bhavya_Abhaykumar_Jain_DS632_Homework 2

Related Documents