The course I'm taking is database management. I have attached the necessary information for question. Please provide solution in detail so i can better understand why. I need solution query for part A and B utilizing SUBQUERY. Thank you in Advance! Part A - Find items with a unit price greater than the unit price of the item with item code ‘005’. Part B - Display all orders placed by customers from ‘curryst’. i.e., Customer Street should be 'curryst'.

The course I'm taking is database management. I have attached the necessary information for question. Please provide solution in detail so i can better understand why. I need solution query for part A and B utilizing SUBQUERY. Thank you in Advance! Part A - Find items with a unit price greater than the unit price of the item with item code ‘005’. Part B - Display all orders placed by customers from ‘curryst’. i.e., Customer Street should be 'curryst'.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter6: Additional Database Objects

Section: Chapter Questions

Problem 10MC

See similar textbooks

Similar questions

A unique identifier for a data row that consists of more than one field is commonly called a: primary plus key composite primary key foreign key none of the above
If a column has high selectivity or cardinality, which index type is most appropriate?a. IOTb. B-treec. bitmapd. function-based index
Db&__Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions:1. Retrieve all rows in Airport table for all the airports in London city.2. Retrieve all British and German passengers.3. Retrieve all names of all the passengers...
Q9) find the least expensive priceQ10) List the UNIQUE v_code of vendors that provide productsQ11) find the most expensive priceQ12) List the number of products by vendor with the average price, include only the rows withaverage price below 10.00Q13) List all vendor rows (including the ones that have no matching products) and all matchingproduct rows
Topic: Databse Prompt: Transform as necessary and then write the XML elements to the appropriate tables in the database.Build SQL chunks for the following queries: What are the titles and prices of all books written by "Galos, Mike"? List the titles and the prices. What is the most recent year of publication of all books written by "O'Brien, Tim". What is the average price of all books in the "Fantasy" genre. Find the number of books in each genre. List the title and author of all books that cost less than the average price of books. XML Syntax: <book id="bk101"> <author>Gambardella, Matthew</author> <title>XML Developer's Guide</title> <genre>Computer</genre> <price>44.95</price> <publish_date>2000-10-01</publish_date> <description></description> </book> <book id="bk102"> <author>Ralls, Kim</author> <title>Midnight…
Write Mysql code The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule. Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs.
CREATE DATABASE COUNTRIES; USE COUNTRIES; DROP TABLE IF EXISTS `City`; CREATE TABLE `City` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Name` char(35) NOT NULL DEFAULT '', `CountryCode` char(3) NOT NULL DEFAULT '', `District` char(20) NOT NULL DEFAULT '', `Population` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=4080 DEFAULT CHARSET=latin1; -- -- Dumping data for table `City` -- -- ORDER BY: `ID` INSERT INTO `City` VALUES (1,'Kabul','AFG','Kabol',1780000); INSERT INTO `City` VALUES (2,'Qandahar','AFG','Qandahar',237500); INSERT INTO `City` VALUES (3,'Herat','AFG','Herat',186800); INSERT INTO `City` VALUES (4,'Mazar-e-Sharif','AFG','Balkh',127800); INSERT INTO `City` VALUES (5,'Amsterdam','NLD','Noord-Holland',731200); INSERT INTO `City` VALUES (6,'Rotterdam','NLD','Zuid-Holland',593321); INSERT INTO `City` VALUES (7,'Haag','NLD','Zuid-Holland',440900); INSERT INTO `City` VALUES (3068,'Berlin','DEU','Berliini',3386667); INSERT INTO `City` VALUES…
MySQL 6. 2. Challenge Updating data A mysql prompt has been opened for you. Using the EPDriver database: Update the trip_total_fare column of the trips table with a value of 25.00 where the trip_datetime_end is NULL
Question: (MySQL Syntax) Write a single UPDATE statement to change the due date for all books borrowed on same day as the borrowing patron's sign-up. These due dates should be changed to exactly 30 days after patron sign-up. Here are the tables: CREATE TABLE book(isbn VARCHAR(100) PRIMARY KEY,title VARCHAR(100) NOT NULL,author VARCHAR(100) NOT NULL,pub_date DATE); CREATE TABLE patron(id INT PRIMARY KEY,first_name VARCHAR(100) NOT NULL,last_name VARCHAR(100) NOT NULL,sign_up DATE NOT NULL); CREATE TABLE borrow(patron INT NOT NULL,book VARCHAR(100) NOT NULL,check_out_date DATE NOT NULL,due_date DATE NOT NULL,PRIMARY KEY(patron, book, check_out_date),FOREIGN KEY (patron) REFERENCES patron(id),FOREIGN KEY (book) REFERENCES book(isbn)); CREATE TABLE late_notice(patron INT NOT NULL,book VARCHAR(100) NOT NULL,check_out_date DATE NOT NULL,notice_date DATE,FOREIGN KEY (patron, book, check_out_date) REFERENCES borrow(patron, book, check_out_date));
A(n) ___________ key is a column in one table that references a primary key in another related table. A(n) ___________ source connects data-bound controls to a dataset.
Baseline requirement: Your search engine should be able to display the first n lines from a public dataset search for the first occurrence based on exact match search for all occurrences based on exact match search for all occurrences based on partial match (start, within, end) search based on your criteria (magic) This is to be done in Python
MySQL CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...6. Find the last name of all employees that were not hired on Tuesday *hint: (UseDATE_FORMAT() function amd the format you need is %W, also use UPPER()7. Find the number of employees in each department who have a manager.8. Find the number of employees for each manager whose employees' minimum salary is greaterthan 5000.9. Find the number of…