1. Write a query to list the first name and last name of those pilots who...
1. Write a query to list the first name and last name of those pilots who were hired after January 1, 2010. Sort your result by the ascending order of last name. Within matching last names, order by first name.
2. Write a query to list flight number, pilot number, pilot last name for all flights whose destinations are using the IN keyword.
3. Write a query to list the names and telephone numbers of the passengers who have reservations on to destination RDU.
4. Count the number of reservations t
5. Write a query to list total fair paid, first name, and last name for all passengers in descending order of last name and first name.
Homework Answers
Add Answer to:
1. Write a query to list the first name and last name of those
pilots who...
Write a query in SQL to list the following information of the artists in movie industry....
Write a query in SQL to list the following information of the artists in movie industry. Limit this information to only 5 artists. Sort the information by age descending order. Full name : first name and last name separated by space Age: Current age Address: State that he resides Contact number: Phone number This is from an artist table, where first_name, last_name, contact_no, address, birth_date are the fields in the table. Birth date in the table...
Can you please write the MySQL Query sentences for the following items below? For example: SELECT...
Can you please write the MySQL Query sentences for the following items below? For example: SELECT * FROM employees; Generate a list of salespeople sorted descending by hire date. Show the ID, first name, last name, hire date, and salary for each salesperson. Generate a list of customers whose last name begins with the letter “M.” Show the first and last names of these customers. Sort the list of customers descending by last name. C. Generate a list of customers...
Problem 33, chapter 7 from Database Systems 13th edition by Coronel Write a query to display...
Problem 33, chapter 7 from Database Systems 13th edition by Coronel Write a query to display the employee number, last name, email address, title, and department name of each employee whose job title ends in the word “ASSOCIATE.” Sort the output by department name and employee title Problem 36, chapter 7 from Database Systems 13th edition by Coronel Write a query to display the number of products within each base and type combination, sorted by base and then by type...
SQL Homework 1. For each reservation, list the reservation ID, trip ID, customer number, and customer...
SQL Homework 1. For each reservation, list the reservation ID, trip ID, customer number, and customer last name. Order the results by customer last name. 2. For each reservation for customer Ryan Goff, list the reservation ID, trip ID, and number of persons. 3. List the trip name of each trip that has Miles Abrams as a guide. 4. List the trip name of each trip that has the type Biking and that has Rita Boyers as a guide. 5....
(TCO 6) Write a query to list the customer first name, last name as a single...
(TCO 6) Write a query to list the customer first name, last name as a single field with a heading of Customer along with the balance sorted by balance from lowest to highest. SalesRep Customer PK ReplD PK varchar(20) varchar(20) decimal(10,2) CustomerID int -OH Last Name FirstName Last Name varchar(20) Commission Rate FirstName varchar(20) Street varchar(20) City varchar(20) Order State char(2) Zipcode char(5) HO. ---OPK OrderID Balance decimal(10,2) ReplD int FK1 CustomeriD OrderDate ShipDate Part int int date date PK...
8. List the names of doctors who have no patients. [Use NOT IN query] IlIness Diagnosis...
8. List the names of doctors
who have no patients. [Use NOT IN query]
IlIness Diagnosis Illness Code Illness Desc Department Pres No Patient N0 Medication Code Dosage Physician JD Last Name Patient-No ness Code Tel Extensian Specialty Assignment Paticnt Medication FnysicianJD Patient No Role patient No Last Name First Name Age Gentder Medicatian Cade On Hand On Order Unit Cost
Write query using (USE ONLY SUBQUERIES) to find first name and last name of all customers that have rented a “music” movie order by last name.
Write query using (USE ONLY SUBQUERIES) to find first name and last name of all customers that have rented a “music” movie order by last name. Using Sakila database
SQL 1--> List slPax.PaxID, slPax.PaxFirstName, slPax.PaxLastName, and slCensus.PaxOrder for passengers with the lastname 'lozano'. Order the...
SQL
1--> List slPax.PaxID, slPax.PaxFirstName, slPax.PaxLastName,
and slCensus.PaxOrder for passengers with the lastname
'lozano'.
Order the list by slCensus.PaxOrder in ascending order.
2-->List slShip.Make, slMaintenance.MaintenanceDate, and
slSupplier.SupplierName for maintenance items with cost between 50
and 75.
Order the list by slMaintenance.MaintenanceDate in ascending
order.
3-->List slShip.Model, slTrip.TripStart, and
slWayPoint.WayPoint for TripID = 118.
Order the list by slFloatPlan.FloatPlanID in descending order.
4-->List slTrip.TripID, slTrip.TripStart, slLaunch.Launch,
Passenger, and slShip.Make for TripID 100. This query provides the
list of passengers and the...
Write a SQL query that shows the price of each order made by customers whose last name starts wit...
Write a SQL query that shows the price of each
order made by customers whose last name starts with the
letter M. Display the order number, the last name on the order, and
the price of the order (Order Price). Show the results with the
highest order price first.
Write a SQL query that determines the most
expensive item purchased in each order (Item Price). Display the
order number, the date of the order, the last name of the customer...
Write a query to display author ID, author first, last name, and the number of subjects...
Write a query to display author ID, author first, last name, and
the number of subjects (book subject count) for authors who have
published books in more than one subject area (book subject).
CHECKOUT PATRON PK Pat ID FK1 Book Num FK2 Pat ID Check Out Date Check Due Date Check In Date Pat FName Pat LName Pat Type BOOK AUTHOR PK Au ID Book Title Book Year Book Cost Book Subject Au FName Au LName Au BirthYear FK1 Pat...
(TCO 6) Write a query to list the customer first name, last name as a single field with a heading of Customer along with the balance sorted by balance from lowest to highest. SalesRep Customer PK ReplD PK varchar(20) varchar(20) decimal(10,2) CustomerID int -OH Last Name FirstName Last Name varchar(20) Commission Rate FirstName varchar(20) Street varchar(20) City varchar(20) Order State char(2) Zipcode char(5) HO. ---OPK OrderID Balance decimal(10,2) ReplD int FK1 CustomeriD OrderDate ShipDate Part int int date date PK...
8. List the names of doctors
who have no patients. [Use NOT IN query]
IlIness Diagnosis Illness Code Illness Desc Department Pres No Patient N0 Medication Code Dosage Physician JD Last Name Patient-No ness Code Tel Extensian Specialty Assignment Paticnt Medication FnysicianJD Patient No Role patient No Last Name First Name Age Gentder Medicatian Cade On Hand On Order Unit Cost
SQL
1--> List slPax.PaxID, slPax.PaxFirstName, slPax.PaxLastName,
and slCensus.PaxOrder for passengers with the lastname
'lozano'.
Order the list by slCensus.PaxOrder in ascending order.
2-->List slShip.Make, slMaintenance.MaintenanceDate, and
slSupplier.SupplierName for maintenance items with cost between 50
and 75.
Order the list by slMaintenance.MaintenanceDate in ascending
order.
3-->List slShip.Model, slTrip.TripStart, and
slWayPoint.WayPoint for TripID = 118.
Order the list by slFloatPlan.FloatPlanID in descending order.
4-->List slTrip.TripID, slTrip.TripStart, slLaunch.Launch,
Passenger, and slShip.Make for TripID 100. This query provides the
list of passengers and the...
Write a SQL query that shows the price of each
order made by customers whose last name starts with the
letter M. Display the order number, the last name on the order, and
the price of the order (Order Price). Show the results with the
highest order price first.
Write a SQL query that determines the most
expensive item purchased in each order (Item Price). Display the
order number, the date of the order, the last name of the customer...
Write a query to display author ID, author first, last name, and
the number of subjects (book subject count) for authors who have
published books in more than one subject area (book subject).
CHECKOUT PATRON PK Pat ID FK1 Book Num FK2 Pat ID Check Out Date Check Due Date Check In Date Pat FName Pat LName Pat Type BOOK AUTHOR PK Au ID Book Title Book Year Book Cost Book Subject Au FName Au LName Au BirthYear FK1 Pat...
Most questions answered within 3 hours.
-
A 8.15- g bullet from a 9-mm pistol has a velocity of 366.0 m/s.
It strikes...
asked 33 minutes ago -
The outstanding bonds of Alpha Extracts have a yield to maturity
of 7.4 percent and a...
asked 29 minutes ago -
The Problem: The Case of the Harmonizing Vacations
Your CEO is exploring partnering with a European...
asked 1 hour ago -
A chemical equation is balanced by adding coefficients in front
of some formulas so that the...
asked 1 hour ago -
From the literature (reference your sources): What are the
lattice parameters of calcite and aragonite? Why...
asked 2 hours ago -
Your system is rejecting the question am asking which is
preceded by a case study. It...
asked 2 hours ago -
3. On January 2, 2000, Larry creates a trust with himself as
trustee. Larry as trustee...
asked 2 hours ago -
A member of the volleyball team spikes the ball. During this
process, she changes the velocity...
asked 2 hours ago -
Are adult gamers less likely to use a gaming console (Xbox,
PlayStation, Wii, etc...) than teen...
asked 3 hours ago -
The University of
Texas recently reported that 43% of college students aged 18-24
would spend their...
asked 3 hours ago -
The length of stay at a specific emergency department in
Phoenix, Arizona, in 2009 had a...
asked 3 hours ago -
. Please give the mechanism for this type of problem. Step by
Step
The toxin that...
asked 3 hours ago