For the remaining questions, use the following table of people:people (id (pk), firstname, lastname, spouse_id (fk))The table was created as:CREATE TABLE people (id INT NOT NULL AUTO INCREMENT PRIMARY KEY,firstname VARCHAR(30), lastname VARCHAR (30), spouse id INT,CONSTRAINT spouse fk FOREIGN KEY (spouse id) REFERENCES people (id));This is some sample data:Participation Activity 9+----| id | firstname | lastname | spouse_id |+1 | Marty2 | Jennifer| McFly| Parker| McFly| Tannen| McFly||3 | Lorraine4 | Biff5 | GeorgeNULL |NULL |5 |NULL |3 |+----+-- 17. Write the SQL statement that will display the following (do not hardcode 'George', 'Lorraine', or anynames, in your statement):| Person | Spouse| George | Lorraine

Using self join between these two table we will get the results for George and Lorraine and to…

Answered: 17. Write the SQL statement that will…

17. Write the SQL statement that will display the following (do not hardcode 'George', 'Lorraine', or any names, in your statement): | Person | Spouse | George | Lorraine

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 15RQ

See similar textbooks

Related questions

Q: Student Name: Student Number: Write a PL/SQL Program to do the following Your Program should request…

A: Answer is given below-

Q: OB. The function must contain a return statement. Oc.It is similar to the PL/SQL procedure except…

A: Which of the following is not true about the PLSQL functions? OPTION : B

Q: Please develop PL/SQL program that asks for a radius of a circle. After user enters a radius number,…

A: Syntax to implement IF statement: IF condition THEN statements; ELSEIF condition THEN…

Q: Create a PL/SQL Program that asks user to enter 2 numbers, then finds an average of two numbers and…

A: PL/SQL program is : SET SERVEROUTPUT ON;DECLAREv_x NUMBER :=&first;v_y NUMBER…

Q: 5. Use XAMPP Control Panel (My SQL) to answer the following questions. Write SQL queries statement…

A: CODE:- Creating table PROPERTY and inserting values in it:- -- create table PROPERTY CREATE…

Q: Exercise 1: Addresses in Bahrain are identified using three numbers separated using commas and one…

Q: The Midnight Coffee Roastery is running a special on decaf coffee. Write an SQL statement that…

A: GIVEN: The Midnight Coffee Roastery is running a special on decaf coffee. Write an SQL statement…

Q: The system variable that records the select statement that SQL * FORMS most recently used to…

A: Question. The system variable that records the select statement that SQL * FORMS most recently used…

Q: Create a program (using sQL strings) that willinsert one record, increase by 8 % the unit price of…

A: the answer is given below :

Q: 31-Create a SQL statement to Display the number of clients for each CType with having less than 2…

A: Here we need group the CType using GroupBy clause and then use Having clause to select only those…

Q: Given the following table: Student ( id, first_name, last name, address, program, phone), which of…

A: Given the following table: Student ( id,first_name, last_name, address,program,phone)which of the…

Q: Below is a table description and its data. The table is not in Third Normal Form (3NF). Explain why.…

A: A relation is said to be in the third normal form if only if the relation is in both first normal…

Q: Assume that you have a product code that has the following format: XXXXNNN Where X is a character…

A: Below is the detailed PL/SQL program to separate the code into its two parts as shown in the above…

Q: Write a function called queryData() which will search the customerArray and output the following…

A: <!DOCTYPE html><html><body> <p>Jeff Smith is a 17 year old Male from London,…

Q: Using a SET operator, Display all names that are used both as a last name and a first name. Example:…

A: SET operators are special type of operators which are used to combine the result of two queries.…

Q: Person(Name, Age, Phone, Extension) Find all names whose Extension starts with 5 folllowed by any…

A: we want it to start from 5, have exactly one character in the second place, which is denoted by the…

Q: Write a SQL statement that will display the product ID, product name, and category only products…

A: In Step 2, an SQL statement is given that will display the product id, product name, and category…

Q: A(n) ___________________ is used within a simple condition to compare two values. A index B…

A: Answer: Option A: Index is used in arrays to present the position of the array values so this option…

Q: Assume that you have a product code that has the following format: XXXXNNN Where X is a character…

A: Answer :

Q: Orders Columns: order_id (int), order_no (char(30)), customer_name (char(100)) Order_Line Columns:…

A: Given that two tables data . Orders tabel contains : order_id(int), order_no(char(30)),…

Q: Code should be in Python, please 1. Prompt the user for a title for data. Output the title. Ex:…

Q: Write the SQL statements to create database objects. la. Create a table with the details shown…

A: Note: - As per our guidelines we can only answer one question at a time. Please resubmit the other…

Q: I have this condition in sql and php it searches things but when there is space or line break in…

A: THe solution for the above given question is given below:

Q: Exercise 1: Addresses in Bahrain are identified using three numbers separated using commas and one…

A: According to bartleby guidelines we need to solve only the first question, so please repost the…

Q: Which of the following is not part of a standard SQL statement? a. Importable programming libraries…

A: Below is the answer to above question. I hope this will be helpful for you..

Q: Hello I just need help creating test cases for the functions below. examples: assertequal,…

A: Lets go step by step 1) Validate_name() True:- false:- 2)validate_company True:- False:-…

Q: 9.use the data which is given as shown bwlow to Write a SQL statement to display the most expensive…

A: Answer :-- SELECT product_id,product_name,price from product where price = (Select MAX(price) From…

Q: When SQL statements are embedded inside 3GL, we call such a program as a. Nested query b. Nested…

A: This mcq is based on SQL language.

Q: IN SQL ** Write a query sentence to display the names, jobs, dates of appointment and employee…

A: Given Columns to display: name, job, appointmentDate,empNo Condition: First column has to be empNo…

Q: Q2) Read from the user his height and weight and print his BMI (Body Mass Index) using the following…

A: Program Approach: Get the inputs from the user using Console.WriteLine() Read inputs using…

Q: Indicate what relational expressions are false. (Choose all that apply) O "Mary" "54"

A: Comparision of the strings : The comparison of two strings is calculated based on the ASCII letter…

Q: a. Write the SQL statement that will return the following result FName LName Program Students…

A: SELECT FName, LName, PName, (SELECT COUNT(*) FROM Student WHERE Student.PCode = Staff.PCode) AS…

Q: Write a stored Procedure Which shows the Product having maximum Price.

A: Stored Procedure in SQL: A stored procedure is a SQL code that can be saved, so if the code is…

Q: Oracle language Display the employee’s name whose salary is within a range that is specified by…

A: Select FIRST_NAME from EMPLOYEE where SALARY >= 10000 and SALARY < 30000;

Q: Create a SQL statement to display the table structure of the CLIENTS table.

A: Select statement in SQL is used to display a table . It can be used with where clause to display…

Q: Appointments AppointmentID 1 P1 2 P2 PatientID AppointmentTime AppointmentDate TreatmentID DentistID…

A: As per out guidelines, we are supposed to answer only 1st 3 questions. Kindly repost the remaining…

Q: Do the steps below in microsoft SQL server management studio. -create Authors and Books relations.…

A: Note : As you have posted multiple sub-parts, I am answering 1st 3 sub parts according to the…

Q: Write SQL code that will retrieve patients whose appointment months are the same as with a patient…

A: Let the Table name be Hospital, to get the data from the table here we use LIKE and Not like…

Q: Please develop PL/SQL program that asks for a radius of a circle. After user enters a radius number,…

A: Syntax to implement IF statement: IF condition THEN statements; ELSEIF condition THEN…

Q: Which statement is used to create a user-defined data type?a. Declareb. Define c. Structured.…

A: User-defined data type: The data types such as Integer, Double and Decimal are in-built data types…

Q: Next, write a SQL statement to create a single column relational table MESSAGE to store variable…

A: NOTE: I HAVE ONLY GIVEN THE ANSWER FOR FOURTH PART AS ASKED BY YOU, IF YOU WISH TO HAVE ANSWERS FOR…

Q: Databases are used to store different kinds of data such as names, currency, text, graphics, etc.…

A: GIVEN: Databases are used to store different kinds of data such as names, currency, text, graphics,…

Q: Use the table below to find the output PRODUCT ID PRODUCT NAME BRAND UNIT PRICE SUPPLIER ID CATEGORY…

A: Required:

Q: Code should be in Python Prompt the user for a title for data. Output the title. Ex: Enter a…

A: Solution :: As we know all python programming is a interpreted high-level general-purpose…

Q: write SQL code that involve calculation by using if else statement

A: Syntax- IF (Expression ) BEGIN -- if expression is true True Statements; END ELSE BEGIN…

Q: SQL PROGRAM Create a function that takes Celsius temperature and returns a Fahrenheit

A: function is given below:

Q: Cônsider a database with the following tables: v Patient(PatientlD. PatientName, NumberOfVisits) v…

A: SUMMARY: - Hence, we got the output after applying all the queries.

Q: Execute the following statements using MYSQL: 1.Create a Trigger "trigger regno" for the salesman…

A: Answer 1) ---------------------------------(trigger) CREATE TRIGGER regno BEFORE INSERT ON salesman…

Question

17. Write the SQL statement that will display the following (do not hardcode 'George', 'Lorraine', or any
names, in your statement):
| Person | Spouse
| George | Lorraine

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Introduction

VIEW

Query

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

You have the following tables: APARTMENTS (ADDRESS, CITY, STATE, RENTER_ID, RENTER_LAST_NAME) RENTERS (RENTER_ID, FIRST_NAME, LAST_NAME) What is the primary key for the APARTMENTS table? (It may be a composite key involving 2 or more fields) What are the foreign keys, if any? What is the primary key for the RENTERS table? What are the foreign keys, if any? What field in RENTERS can be eliminated so that the RENTERS table is normalized?
Problem 22 Insert the following customer into the CUST_MYSQL table, allowing the AUTO_INCREMENT attribute set up in Problem 20.a and Problem 20.b to generate the customer number automatically: CUST_LNAME CUST_FNAME CUST_BALANCE Powers Ruth 500
Convert the following table to an equivalent collection of tables that are in third normal form. This table contains information about patients of a dentist. Each patient belongs to a household. Patient (HouseholdNum, HouseholdName, Street, City, State, PostalCode, Balance, PatientNum, PatientName, (ServiceCode, Description, Fee, Date)) The following dependencies exist in the Patient table: PatientNum → HouseholdNum, HouseholdName, Street, City, State, PostalCode, Balance, PatientName HouseholdNum → HouseholdName, Street, City, State, PostalCode, Balance ServiceCode → Description, Fee PatientNum, ServiceCode → Date
Problem 22 Insert the following customer into the CUST_MYSQL table, allowing the AUTO_INCREMENT attribute set up in Problem 20.a and Problem 20.b to generate the customer number automatically: CUST_LNAME CUST_FNAME CUST_BALANCE Powers Ruth 500 This is what problem 20.a said, and got right: Using MySQL, create a table named CUST_MYSQL with the same fields as in Problem 16, except, use the AUTO_INCREMENT feature for the CUST_NUM field. This is what problem 20.b said, and got right: Using MySQL, alter the table to populate the CUST_NUM field, beginning the increment with 2000.
Write SQL query to create the.given table:Worker(Worker Id int primary key, Name varchar(15), Department varchar(10))
Write SQL query to create the.given table: Worker(Worker Id int primary key, Name varchar(15), Department varchar(10))
Some rows of the table STUDENT are shown below: CODE NAME DEPARTMENT GPA YEAR 291 ALEX PSI 3.1 1992 938 MICHELE PHY 2.3 1992 931 JHON MD 3.3 2001 182 JOE MD 3.4 2002 190 REY PHY 2.0 2001 330 RON PSI 3.9 2001 You want the name all departments that have a department GPA average of 2004 greater than the global GPA average. Which query gives you the desired result? a. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT); b. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 AND AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT) GROUP BY DEPARTMENT; c. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT GPA FROM STUDENT GROUP BY DEPARTMENT); d. SELECT * FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT);
Given the relation members(mid: INTEGER, name: CHAR(30), age: INTEGER, tier: INTEGER) Write a SQL query to show the average age in each tier with more than 2 members, including how many members in each tier, for tiers above 5 in ascending order, with labels for aggregate fields shown.
Write an SQL query to fetch “FIRST_NAME” from Worker table using the alias name as <WORKER_NAME>. ii.Write an SQL query to fetch unique values of DEPARTMENT from Worker table.
You have two tables teachers and students. Each student belongs to a teacher. Complete the query to join the tables on the teacher id. SELECT * FROM students JOIN teachers ON _________ ; a. Students.teacher_id = teachers.id b. teachers_id = id c. teachers.id = student.id d. teachers = students.id
This is the problem: (from Database Systems Book, 13th ed) Write a query to display the author last name, first name, book title, and replacement cost for each book. Sort the results by book number and then author ID (Figure P7.92). (25 rows)
Write MS SQL query to retrieve exployee with second highest salary from employee table Employee(Id, name, salary)