Using Oracle SQL created the commands used to achieve what is asked below. List the full name
Question:
Using Oracle SQL created the commands used to achieve what is asked below.
List the full name (first and last name) and phone number for students that live in Newark, NJ.
Sort on last name and first name.
For all 300 level courses (300-399), list the course number, prerequisite course number and prerequisite course description. Sort by course number.
List the course number and description for all 100-level courses taught by Charles Lowry.
Arrange the list in order of course number.
List the grade type code, description and number per section (a column in the grade_type_weight table) of all grades in course 144. Arrange by description.
Provide an alphabetic list of students (student last name followed by first name) who have an overall grade average of 93 or higher. The name should be one column, last name first and sorted on last name then first name.
APPENDIX D STUDENT DATABASE GRADE CONVERSION LETTER GRADE (PO VARCHAR22) NOT NULL GRADE POINT NUMBER(3.35 NOT NULL NUMBER 3,0 NOTNILL NUMBER(3, NOT NULL VARCHAR230) NOT NULL CATE NOT NULL VARCHAR2(30) NOT NULL CATE NOT NULL MAX GRADE MN GRADE CREATED BY CREATED CATE MOOFED BY MOOFED DATE GRADE STUDENT DIPO(K) SECTION D IPKOPO GRADE TYPE CODE (PFK) CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE GRADE CODE OCCURRENCE (PC NUMBER(380) NUMERIC GRADE COMMENTS FINAL GRADE CREATED BY CREATED DATE MOOFED BY MOOFED DATE ENR STU FK STUDENT STUDENT D (RK) SALUTATION FIRST NAME LAST NAME ENROLLMENT STUDENT D (PKPK) NUMER) NOT NULL SECTION ID(PK)(FK) NUMBER(80) ENROLL DATE NOT NULL NOT NULL CATE MAR NULL VARCHAR2(3 NOT NULL DATE NOT NULL VARCHARX30 NOT NULL DATE NOT NULL STREET ADORESS ZP(FK) PHONE SCHEMA EMPLOYER REGISTRATION DATE DATE CREATED BY CREATED DATE NAK NUMBER CHAR(2) MODIFIED BY MOOFED DATE NUMBER (30) NOT NULL MAL VARCHAR2000 VARCHAR(30) NOT MALL DATE NOT NULL VARCHAR(30) NOT NULL NOT NAL DATE OR ENR FK NOT NALL NOT NULL NOT NULL NOT MALL NUMBER(80) NOT NULL VARCHAR NAL VARCHAR(2) MULL VARCHAR2(25) NOT NULL VAROHAR NALL VARCHAR(5) NOT NULL VARCHAR(15) NILL VARCHAR(50) NULL NOT NULL VAROHAR2(30) NOT NULL DATE NOT NULL VARCHAR(30) NOT NULL DATE NOT NULL ENR_SECT FK COURSE COURSE NO (PK) NUMBER(80) NOT NULL DESCRIPTION VARCHARE(50) NOT NULL NAL NULL VARCHAR(30) NOT NULL PATE NOT NAL VARCHAR2(30) NOT NULL DATE NOT NULL COST NUMBERS 21 PREREQUISITE (FK) NUMBER) CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE SECT_CRSE FK GRADE TYPE WEIGHT SECTION_D(P)(FK) GR GRTW FK NUMBER PER SECTION GRADE TYPE CODE (PFO CHAR GR GRTW FK NUMBER PER ORSE ORSE PK GRADE TYPE GRADE TYPE CODE (PO OHAR(2) STU ZP FK DESCRIPTION CREATED BY CREATED DATE MODIFIED BY MODIFIED CATE NOT NULL VARCHAR(50) NOT MAL VARCHAR(30) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL GRTW_GRTVP FK GRTW SECT FK NUMBER(8,0) NUMBER, NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL SECTION NUMBER(3,0) PERCENT OF FINAL GRADE NUMBER(3,0) DROP LOWEST CHAR(1 CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL LICOPED BY VARCHAR2(30) NOT NULL MODRED DATE DATE NOT NULL SECTION SECTION D(P) COURSE NO (FO SECTION NO START DATE TIME LOCATION INSTRUCTOR D (FK) NUMBER(8,0) CAPACITY NUMBER(30 MAL CREATED BY VARCHAR230) NOT NULL CREATED CATE DATE NOT NULL MOOFED BY VARCHAR230) NOT NULL MOOFED DATE CATE NOT NULL NUMBER NUMBER 8.0 NLA3 DATE VARCHAR250) NULL www NOT NULL NOT NULL NOT NULL NOT NULL MAL SECT_INST.FK INSTRUCTOR INSTRUCTOR D (PNAK80) NOT NULL SALUTATION VARCHARZ SI NULL FIRST NAME VARCHAR(25 NULL LAST NAME VARCHAR(25) NULL STREET ADDRESS VARCHAR2(50) NULL ZP (FK) VARCHARIS NILL PHONE VARCHAR(15) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED CATE DATE NOT NU NULL MOORED BY VARCHAR2(30) NOT NUL MOORED DATE DATE NOT MAL NST ZP K ZIPCODE 2P ( CITY STATE CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MODIFIED BY VARCHAR2(30) NOT NULL MODIFIED DATE DATE NOT NULL VAROHARRIS NOT NELL MALL VARCHAR21251 VARCHAR212) NULL APPENDIX D STUDENT DATABASE GRADE CONVERSION LETTER GRADE (PO VARCHAR22) NOT NULL GRADE POINT NUMBER(3.35 NOT NULL NUMBER 3,0 NOTNILL NUMBER(3, NOT NULL VARCHAR230) NOT NULL CATE NOT NULL VARCHAR2(30) NOT NULL CATE NOT NULL MAX GRADE MN GRADE CREATED BY CREATED CATE MOOFED BY MOOFED DATE GRADE STUDENT DIPO(K) SECTION D IPKOPO GRADE TYPE CODE (PFK) CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE GRADE CODE OCCURRENCE (PC NUMBER(380) NUMERIC GRADE COMMENTS FINAL GRADE CREATED BY CREATED DATE MOOFED BY MOOFED DATE ENR STU FK STUDENT STUDENT D (RK) SALUTATION FIRST NAME LAST NAME ENROLLMENT STUDENT D (PKPK) NUMER) NOT NULL SECTION ID(PK)(FK) NUMBER(80) ENROLL DATE NOT NULL NOT NULL CATE MAR NULL VARCHAR2(3 NOT NULL DATE NOT NULL VARCHARX30 NOT NULL DATE NOT NULL STREET ADORESS ZP(FK) PHONE SCHEMA EMPLOYER REGISTRATION DATE DATE CREATED BY CREATED DATE NAK NUMBER CHAR(2) MODIFIED BY MOOFED DATE NUMBER (30) NOT NULL MAL VARCHAR2000 VARCHAR(30) NOT MALL DATE NOT NULL VARCHAR(30) NOT NULL NOT NAL DATE OR ENR FK NOT NALL NOT NULL NOT NULL NOT MALL NUMBER(80) NOT NULL VARCHAR NAL VARCHAR(2) MULL VARCHAR2(25) NOT NULL VAROHAR NALL VARCHAR(5) NOT NULL VARCHAR(15) NILL VARCHAR(50) NULL NOT NULL VAROHAR2(30) NOT NULL DATE NOT NULL VARCHAR(30) NOT NULL DATE NOT NULL ENR_SECT FK COURSE COURSE NO (PK) NUMBER(80) NOT NULL DESCRIPTION VARCHARE(50) NOT NULL NAL NULL VARCHAR(30) NOT NULL PATE NOT NAL VARCHAR2(30) NOT NULL DATE NOT NULL COST NUMBERS 21 PREREQUISITE (FK) NUMBER) CREATED BY CREATED DATE MODIFIED BY MODIFIED DATE SECT_CRSE FK GRADE TYPE WEIGHT SECTION_D(P)(FK) GR GRTW FK NUMBER PER SECTION GRADE TYPE CODE (PFO CHAR GR GRTW FK NUMBER PER ORSE ORSE PK GRADE TYPE GRADE TYPE CODE (PO OHAR(2) STU ZP FK DESCRIPTION CREATED BY CREATED DATE MODIFIED BY MODIFIED CATE NOT NULL VARCHAR(50) NOT MAL VARCHAR(30) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL DATE NOT NULL GRTW_GRTVP FK GRTW SECT FK NUMBER(8,0) NUMBER, NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL SECTION NUMBER(3,0) PERCENT OF FINAL GRADE NUMBER(3,0) DROP LOWEST CHAR(1 CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL LICOPED BY VARCHAR2(30) NOT NULL MODRED DATE DATE NOT NULL SECTION SECTION D(P) COURSE NO (FO SECTION NO START DATE TIME LOCATION INSTRUCTOR D (FK) NUMBER(8,0) CAPACITY NUMBER(30 MAL CREATED BY VARCHAR230) NOT NULL CREATED CATE DATE NOT NULL MOOFED BY VARCHAR230) NOT NULL MOOFED DATE CATE NOT NULL NUMBER NUMBER 8.0 NLA3 DATE VARCHAR250) NULL www NOT NULL NOT NULL NOT NULL NOT NULL MAL SECT_INST.FK INSTRUCTOR INSTRUCTOR D (PNAK80) NOT NULL SALUTATION VARCHARZ SI NULL FIRST NAME VARCHAR(25 NULL LAST NAME VARCHAR(25) NULL STREET ADDRESS VARCHAR2(50) NULL ZP (FK) VARCHARIS NILL PHONE VARCHAR(15) NULL CREATED BY VARCHAR2(30) NOT NULL CREATED CATE DATE NOT NU NULL MOORED BY VARCHAR2(30) NOT NUL MOORED DATE DATE NOT MAL NST ZP K ZIPCODE 2P ( CITY STATE CREATED BY VARCHAR2(30) NOT NULL CREATED DATE DATE NOT NULL MODIFIED BY VARCHAR2(30) NOT NULL MODIFIED DATE DATE NOT NULL VAROHARRIS NOT NELL MALL VARCHAR21251 VARCHAR212) NULL
Expert Answer:
Ans 1 select firstnamelastnamephone from student s join zip ... View the full answer
Discovering Advanced Algebra An Investigative Approach
ISBN: 978-1559539845
1st edition
Authors: Jerald Murdock, Ellen Kamischke, Eric Kamischke
Students also viewed these accounting questions
-
In site 4, the first and last years are both NA's. Come up with some variation on the left-hand or right-hand estimate to estimate the total number of aspen. Biologists measure the number of aspen...
-
The pictures below show the first and last steps of bucket problems similar to Example A. Write a statement for each problem. a. b. l0-liter -liter buckct buckot 10-liter 7-liter buckct bucket
-
May you help me with questions "I" and "J" Question I: How would an improvement in one of the ratios say, the DSO would affect Computron's stock price. For example , if the company could improve its...
-
Your organisation requires all new business documents be scanned and saved electronically once they are checked for accuracy. They also require that you update the database system with the new...
-
Recompute the answer to problem 8 based on a portfolio standard of 16 percent. In terms of capital market theory, explain why KP has increased.
-
The table shows the overall scores and the prices for a random sample of nine different models of elliptical exercise machines. The overall score represents the ergonomics, exercise range, ease of...
-
An asset is classified as current if it a. was purchased within the last six months. b. will become cash, be sold, or be used up within 12 months. C. was purchased with cash. d. will last longer than...
-
Retailers Nordstrom and Walmart are positioned very differently in the marketplace. Using the characteristics of store retailers addressed in the chapter, which includes merchandise assortment, level...
-
Goal is to Identify methods for organizing ideas to show relationships. Instructions Despite the undeniable upsides of social networking, social media sites track users and sell their information....
-
A small cube moves at a constant velocity v= 8.5 m/s on the smooth horizontal floor until it reaches the bottom of an inclined plane at = 37 above the horizontal. The cube slides up the inclined...
-
A particle of mass m is moving along the x-axis with speed u when it collides with a particle of mass 2m initially at rest. After the collision, the first particle has come to rest, and the second...
-
(16 points) Let g(x) = 3x4 - 2x + 1. (a) Find the critical points, if any of g(x). (b) Identify all intervals in which g(x) is decreasing. (c) Identify all intervals in which g(x) is concave up.
-
How do multifunctional teams navigate the interplay between autonomy and interdependence, striking a delicate balance between empowering individual agency and fostering collective accountability,...
-
The asset turnover of Brandburg and Associates is 7 . 2 . The total assets of the company are $ 8 8 , 0 0 0 . What were Brandburg and Associates' net sales?
-
Garcel Inc. held unfinished inventory at a cost of $ 8 5 , 0 0 0 with a sales value of $ 1 2 5 , 0 0 0 . The inventory will cost $ 1 0 , 5 0 0 to complete. The normal profit margin is 3 0 % of sales....
-
The pizzeria's cost formulas appear below: Fixed Cost per Cost per Month Pizza Cost per Delivery Pizza ingredients $ 4.50 Kitchen staff $ 5,930 Utilities $ 620 $ 0.40 Delivery person Delivery vehicle...
-
Simplify. (6x) Assume that the variable represents a positive real number.
-
suppose a nickel-contaminated soil 15 cm deep contained 800 mg/kg Ni, Vegetation was planted to remove the nickel by phytoremediation. The above-ground plant parts average 1% Ni on a dry-weight bas...
-
Identify the domain and range of cos y = x and y = cos-1 x.
-
As you learned in Chapter 4, the graphs of all quadratic functions have a line of symmetry that contains the vertex and divides the parabola into mirror-image halves. Consider this table of values...
-
a. The following readings were taken from a display outside the First River Bank. The display alternated between °F and °C. However, there was an error within the system that calculated the...
-
Solve Prob. 8-48 using Castigliano's theorem. Data From Problem 8.48 = ABC 6.5(103) mm IBC 100(10) mm+ AAB = 18(10) mm IAR 400(10) mm+ DA = 3 m B -50 kN 1 m
-
Solve Prob. 8-40 using Castigliano's theorem. Data From Problem 8.40 2 k/ft 8 ft 8 ft B
-
Solve Prob. 8-53 using Castigliano's theorem. Data From Problem 8.53 8 k 10 ft. 8 ft D A B
Study smarter with the SolutionInn App