Using RelaX and the sample database, create the RA expression to answer the following query: Find the names of Dealers who sell some Black Car Which of the options below is the correct result set? (Note: a new row in the result set is indicated by the "|" symbol in the answers options) CarsMax | MaxiCar | SuperCars | Lord OfCars CarsMax | MaxiCar | SuperCars | LordOfCars | CarsUnited CarsMax | MaxiCar | SuperCars | LordOfCars | CarsUnited | Cars4All BestCars | CarValue | FortCars | Carvana | CarsFast | Engines2Go DriversFirst | WestCars | SouthMotors O FortCars | WestCars | CarsUnited | Engines2Go | DriversFirst O Cars Max | MaxiCar | SuperCars BestCars | CarValue | FortCars | Carvana | CarsFast DriversFirst | WestCars | SouthMotors | DriversFirst CarsMax | MaxiCar You will be using Relax again to help you build your RA expressions and answer questions based on a database model with the following schema: Cars (c_id:number, c_brand:string, color:string, c_condition:string) Dealers (d_id:number, d_name:string, d_location:string) Inventory (c_id:number, d_id:number, costpercar:number, instock:number) Note: Inventory represents cars sold by dealers.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

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!)
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';
3. Run a query that gives the average grade on the final exam for male students and for femalestudents. Round that number to 1 decimal place only.
Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.
1) Write the SQL code to add a column that shows the full name of the Employee in the Employee Table. The expecting format should be “Firstname Initial Lastname” (e.g., “John G News” for the EMP_NUM 101) 2) Write the SQL code to add a binary variable “Hire_prior_2000” in the Employee table. If the hire year (year of hire needs to be identified) is prior to 2000, then Hire_prior_2000=1, other wise Hire_prior_2000=0.
Create "automatically" the table header represented by the left column, the functions used mysql_list_fields and mysql_field_name
Question 6 To get all the variables named x1 through x15 (out of 30 variables that start with x) from data, you could use O filter(data starts with("x")) select(flights."x") Oselect(data.num_range("x"1:15) Opick(flights.starts with("x")) Question 7 To reverse sort the nycflights13::flights data set by month and then by day, you would use O sort values(flights.day.month.descending-TRUE) O filter(flights.desc(month).desc(day)) O filter(flights.desc(day).desc(month)) Osort values(flights,month.day.ascending FALSE) Question 8 To get all the variables from the flights like "arr_delay" and "dep_delay", you could use O filter(flights,ends_with("_delay")) O select(flights.""_delay") O select(flights,ends_with("_delay")) Opick(flights,ends_with("_delay"))
The given SQL creates a Song table and inserts some songs. The first SELECT statement selects songs released after 1992. The second SELECT statement selects the release year for song with ID 800. Create a third query that combines the two existing queries. The first SELECT should be the outer query, and the second SELECT should be the subquery. The ORDER BY clause should appear after the subquery. Run your solution and verify the new query returns a result table with five rows, all with release years after 1992. CREATE TABLE Song (ID INT,Title VARCHAR(60),Artist VARCHAR(60),ReleaseYear INT,Genre VARCHAR(20),PRIMARY KEY (ID)); INSERT INTO Song VALUES(100, 'Hey Jude', 'Beatles', 1968, 'pop rock'),(200, 'You Belong With Me', 'Taylor Swift', 2008, 'country pop'),(300, 'You\'re Still the One', 'Shania Twain', 1998, 'country pop'),(400, 'Need You Now', 'Lady Antebellum', 2011, 'country pop'),(500, 'You\'ve Lost That Lovin\' Feeling', 'The Righteous Brothers', 1964, 'R&B'),(600, 'That\'s…
Write a SELECT statement that returns the following columns from the PRODUCT_INFORMATION table. Sort the results by PRODUCT_ID in ascending order. 1. PRODUCT_ID 2. PRODUCT_NAME 3. LIST_PRICE ○ Use the TO_CHAR function to convert LIST_PRICE to a character string with the currency formatting Give this field an alias of PRICE
6.7 LAB - Create Vehicle and EventVehicle tables The California DMV's completed table diagram is presented in the zyBook. The following is a portion of the table di Vehicle VehicleID TypeCode R YearNumber R MakeCode R ModelName R PlateID R VehicleEvent StateCode R -restrict- • VehicleID RegistrationDate -restrict- • EventNumber
Using the Winners table from Figure 12-2, write a parameter query that selects only ananimated picture’s Year field.
Q1. Please write a query statement from emp table to display employee's empno, ename, length of ename, number of 'S',and number of 'L'. SQL> SELECT empno AS "EmpNo", ename AS "Emp Name", ... AS "Name Length", .... AS "# Of S", .... AS "# Of L"FROM emp; [IMAGE below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing