Question: 9. Write a SELECT statement that returns these column names and data from the Students table: LastName FirstName EnrollmentDate GraduationDate The LastName column The FirstName

9. Write a SELECT statement that returns these column names and data from the Students table:

LastName FirstName EnrollmentDate GraduationDate

The LastName column The FirstName column The EnrollmentDate column The GraduationDate column

Return only the rows where the EnrollmentDate column is greater than 12-01-2019 and the GraduationDate column contains a null value.

10. Write a SELECT statement that returns these columns and data from the Tuition table, along with a constant value and two calculated values:

FullTimeCost PerUnitCost Units TotalPerUnitCost

TotalTuition

The FullTimeCost column

The PerUnitCost column

A column thats calculated by multiplying the per unit cost by the units

A column thats calculated by adding the full time cost to the total per unit cost

9. Write a SELECT statement that returns these column names and data

from the Students table: LastName FirstName EnrollmentDate GraduationDate The LastName column The

FirstName column The EnrollmentDate column The GraduationDate column Return only the rows

where the EnrollmentDate column is greater than 12-01-2019 and the GraduationDate column

Select * from courses Departments Instructorld 1 1 4 5 2 8 6 16 5 7 9 1 11 1 4 4 5 1 1 1 4 6 16 100 % Results i Messages CourselD CourseNumber Course Description CourseUnits 1 1 36598 Beginning Accounting 3 2 2 48926 Abstract Algebra 3 3 3 14862 Primary Education 3 4 4 54321 Anatomy 3 5 5 82754 Social Psychology 3 6 6 13524 Statistical Analysis 3 7 7 24653 Intro to Marketing 3 8 8 22679 Intro to Calculus 3 9 9 98765 Intermediate Accounting 3 10 10 96032 Social Media 3 11 11 58230 Physiology 3 12 12 81256 Intro to Management 3 13 13 64321 Secondary Education 3 14 14 32751 Business Writing 2 15 15 46972 Biology 4 16 16 15487 Music Theory 3 17 17 28177 Classic Literature 3 18 18 90908 Educational Theory 3 19 19 55783 Shakespeare 3 20 20 63284 Population and Demo... 3 21 21 74832 Creative Writing 3 22 22 33218 Marching Band 2 23 23 37645 Composition 3 24 24 84937 Microbiology 4 25 25 44386 Trigonometry 3 1 7 8 2 1 10 3 12 15 13 15 O W U W W NW U10 7 9 2 12 10 3 4 14 SQL Query 14.sql - ...J3Q8DS\smitt (51))* + X SQLQuery13.sql - L...J3Q8DS\smitt (52))* SELECT * FROM instructors | Status F DepartmentChairman 1 0 FirstName Billy William Rachel Gene NULL L 0 LL LL 1 0 F 1 0 100 % Results i Messages Instructorld LastName 1 1 Brown 2 2 Thomas 3 3 Amundsen 4 4 Green 5 5 McGregor 6 6 Paxton 7 7 Rogers 8 8 Smith 9 9 Connors 10 10 Jones 11 11 Vilma 12 12 Thomas 13 13 Black 14 14 Warren 15 15 Drew 16 16 Gallegos Arnold NULL 0 1 9 Hire Date AnnualSalary DepartmentID 2016-01-10 77500.00 1 2016-03-30 38500.00 3 2016-06-05 79000.00 6 2016-08-02 75000.00 1 2017-01-03 74000.00 4 2017-07-15 36000.00 5 2017-10-22 38000.00 1 2018-02-05 73000.00 2 2018-03-04 71500.00 7 2018-09-21 74000.00 3 2018-11-18 35500.00 1 2019-01-17 35500.00 5 2019-04-20 34000.00 2 2019-07-14 33000.00 4 2019-08-25 72000.00 3 2020-03-23 64000.00 6 1 1 John Daniel Sally Jonathan Derrick Bill Angela Daniel Tomas 0 0 0 O O 0 Results StudentID Graduation Date 2019-12-14 1 1 2 2 3 2019-12-14 2019-05-07 3 4 4 2019-12-14 5 5 6 NULL 2019-12-14 2019-05-07 7 8 NULL 9 10 10 NULL NULL NULL 11 11 12 12 13 13 14 14 15 15 16 16 17 NULL 2019-12-14 NULL NULL NULL NULL NULL NULL NULL NULL 17 18 18 19 Messages LastName FirstName Howard Amber White George MacNamara Tony Welch Jonathan Taylor Donna Price Rose Rodriguez Jesse Williams Bonnie Kent Thomas Kramer Maggie DeLorean Cameron Sanchez Frank Smith Roberta Hoffman Wilma Bonwell Brian Clement Cal Patrick Charles Landry William Morrisey Monica Butler George Yount Anderson Rincon Anthony Hallowell Jimmy Flores Jesus Camden James Easton Barney Sommers Tanya Jones Andrew Jackson Floyd Geary Annette Osborne Letitia Manning Vincent Goodell Conner Griffin Gerald Gardner Faye Franks Karen Johnson Timothy Walker Andrew Cramsden Walter 19 EnrollmentDate 2015-12-18 16:44:26 2015-12-20 11:12:26 2015-12-21 09:21:55 2015-12-21 13:23:10 2015-12-28 10:32:16 2016-01-02 12:37:31 2016-01-03 13:08:37 2016-01-03 15:44:56 2016-07-15 11:14:23 2016-07-15 17:02:45 2016-07-18 12:48:43 2016-07-20 09:37:53 2016-07-22 11:18:25 2016-12-10 15:31:28 2016-12-12 14:22:53 2016-12-14 16:42:11 2016-12-22 08:43:48 2017-01-02 11:28:49 2017-01-04 10:42:06 2017-07-12 13:05:41 2017-07-18 14:21:07 2017-12-08 09:55:15 2017-12-19 13:44:25 2018-01-03 16:23:47 2018-01-04 11:12:31 2018-01-04 14:14:02 2018-07-22 15:41:12 2018-07-24 10:53:26 2018-07-25 09:27:53 2018-07-12 09:33:47 2018-12-12 17:14:22 2018-12-14 15:37:43 2019-01-02 14:21:58 2019-01-02 16:04:04 2019-07-22 08:15:57 2019-07-23 10:42:03 2019-08-04 09:01:04 2019-08-05 13:48:26 2019-12-15 10:18:37 20 20 21 21 22 22 NULL NULL 23 23 24 24 NULL NULL 25 25 26 26 NULL NULL 27 27 28 28 29 29 30 30 31 31 NULL NULL NULL NULL NULL NULL NULL 32 32 33 33 34 34 35 35 NULL NULL 36 36 37 37 NULL NULL 38 38 39 39 NULL Select * from Tuition 100 % Results Bi Messages PartTimeCost FullTimeCost PerUnitCost 1 750.00 1250.00 62.50

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!

6. Write a SELECT statement that returns these column names and data from the Students table: FirstName LastName EnrollmentDate CurrentDate MonthsAttended The FirstName column The LastName column The...

Return only the top 2 0 percent of instructors based on annual salary. 8 . Write a SELECT statement that returns these column names and data from the Students table: LastName The LastName column...

Write a 3 : Panasonic cell. MEADSET 6 . Write a SELECT statement that returns these column names and data from the Students table: FirstName The FirstName column LastName The LastName column...

4. Write a SELECT statement that returns these column names and data from the Instructors table: LastName FirstName AnnualSalary The LastName column The FirstName column The AnnualSalary column...

MySQL Assignment Your Portfolio Project consists of two parts, a lesson learned reflection report and a database design and analysis project. Part 1: Lessons Learned and Reflection Write a 2- to...

write a Select statement that returns these column names snd data from the instructors table: Last name the lastname column. FirstName the FirstName column AnnualSalary The annualsalary column

MySQL Query 2. Write a SELECT statement that returns these column names and data from the order_instruments table: item_id The item_id column item_price The itemprice column discount amount The...

Using the My Guitar Shop database you installed in Module 1 , develop the following queries. SUBMIT A SCREENSHOT OF EACH STEP. 1 . Write a SELECT statement that returns these column names and data...

MySQL - Please provide screenshot /******************************************************** * This script creates the database named my_guitar_shop...

Create the following SQL queries using the specified DML statement in the query window. Comment each step in the script. A. Write a SELECT statement that returns these columns: A. The DepartmentName...

Does the release of a Harry Potter book lead children to spend more time reading and thus reduce the number of accidents they have? Doctors in England compared the number of emergency room visits due...

The chapter identified some problems with ROI-type measures and suggested that residual income reduces some of them. Why do you think that ROI is a more common performance measure in practice than...

Which of the following day count conventions applies to a US Treasury bond? Actual / 3 6 0 3 0 / 3 6 0 Actual / 3 6 5 Actual / Actual ( in period )

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

2. How were various roles filled?

2. When the speaker is done, the facilitator asks the group, Can you explain why? or What did he or she mean by that?

4. Do you believe that all people are of equal value, regardless of age, race, religion, culture, or gender? __ always __ usually __ occasionally __ seldom __ never true