If the DOCTORS table has the following columns, and you want to write a SELECT statement to return the Doctors name and join_year who were joined before 2000, and after 2018.

Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order.   (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)

In the BOOK_PRICING table, you should indicate that the Category field is not being utilized. Confirm that the column is no longer an option to choose.

The InstantRide User Satisfaction team requires the average and maximum number of rides users have taken so far with InstantRide. In addition, they would like to know the total number of travels. However, they need these details with the corresponding column names Average, Maximum and Total by using the AVG, MAX and SUM functions. In order to accomplish this, you will first need to create a derived table from the TRAVELS table to pass the TRAVEL_ID count to the three mathematical functions.

the employee table have the following . ask user what is the employee_id and how much employee wants to contribute 2 substitutions variable from end user &emp_id      &contribution_amount If employee salary is in between $1000-$3999 And if  employee's contribution amount is less than $100 then company match $100                   if  employee's contribution amount is greater than 100 but less than $200 then company match $75                  if  employee's contribution amount is greater than $200 then company match $50 $4000-$6999 And if  employee's contribution amount is less than $100 then company match $150                   if  employee's contribution amount is greater than 100 but less than $200 then company match $100                  if  employee's contribution amount is greater than $200 then company match $75  $7000-$12000And if  employee's contribution amount is less than $100 then company match $200                   if  employee's contribution amount is greater than…

Modify the SELECT statement to select the title and release date of PG-13 movies that are released after February 1, 2008. Run your solution and verify the result table shows just the titles and release dates for The Dark Knight and Crazy Rich Asians.       CREATE TABLE Movie (  ID INT AUTO_INCREMENT,  Title VARCHAR(100),  Rating CHAR(5) CHECK (Rating IN ('G', 'PG', 'PG-13', 'R')),  ReleaseDate DATE,  PRIMARY KEY (ID)); INSERT INTO Movie (Title, Rating, ReleaseDate) VALUES  ('Casablanca', 'PG', '1943-01-23'),  ('Bridget Jones\'s Diary', 'PG-13', '2001-04-13'),  ('The Dark Knight', 'PG-13', '2008-07-18'),  ('Hidden Figures', 'PG', '2017-01-06'),  ('Toy Story', 'G', '1995-11-22'),  ('Rocky', 'PG', '1976-11-21'),  ('Crazy Rich Asians', 'PG-13', '2018-08-15'); -- Modify the SELECT statement:SELECT *FROM MovieWHERE ReleaseDate < '2000-01-01';

Assume the PRODUCT table contains multiple rows. The following code would include: SELECT P_DESCRIPT, P_PRICE FROM PRODUCT WHERE P_CODE IN(SELECT P_CODE FROM LINE GROUP BY P_CODE HAVING COUNT(*) > 1); Group of answer choices   A) Select the products that have been ordered before. B) Select the products that have been ordered at least once. C) Select the products that have been ordered at least twice. D) An error message.

What is the main difference between the set operators and the join?

Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.

The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be between 10.0 and 20.0 BirthDate - date, must be on or after Jan 1, 2015 Insert the following data into the Horse table: RegisteredName Breed Height BirthDate Babe Quarter Horse 15.3 2015-02-10 Independence Holsteiner 16.0 2017-03-13 Ellie Saddlebred 15.0 2016-12-22 NULL Egyptian Arab 14.9 2019-10-12