Question: create table Person(name VARCHAR(30), age int, gender VARCHAR(10)); create table Frequents(name VARCHAR(30), pizzeria VARCHAR(30)); create table Eats(name VARCHAR(30), pizza VARCHAR(30)); create table Serves(pizzeria VARCHAR(30), pizza

create table Person(name VARCHAR(30), age int, gender VARCHAR(10)); create table Frequents(name VARCHAR(30), pizzeria VARCHAR(30)); create table Eats(name VARCHAR(30), pizza VARCHAR(30)); create table Serves(pizzeria VARCHAR(30), pizza VARCHAR(30), price float);

Using SQL

Find all pizzerias frequented by at least one person under the age of 18 and at least one person over the age of 30. Print out all the quintuples (pizzeria, person1, age1, person2, age2), where person1 and person2 are persons who frequent the pizzeria, and person1 is under the age of 18 and person2 is over the age of 30.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Table 8 - 9 As the high bidder on a monstrous storage locker in Rancho Cucamonga, Darrell discovers much to his dismay that no collectibles or priceless works of art have been seeded in his locker....

Write Sql queries that answer the question below (one nested query per question) in the ANSI-style join. The query answers must not contain duplicates, but you should use the SQL keyword distinct...

JDBC API of package java. sql Exercise 24.4 (Employee Database) in Java How to Program 10th Edition. It reads: Write an application that allows the user to: a) Add employees to the employee table b)...

Hello, I am trying to complete Excersize 24.4 (Employee Database) in Java How to Program 10th Edition. It reads: Write an application that allows the user to: a) Add employees to the employee table...

Create the pizza database using pizza.sql which is: /* Create the schema for our tables */ create table Person(name VARCHAR(30), age int, gender VARCHAR(10)); create table Frequents(name VARCHAR(30),...

Provide the $QL for the following data requests. Your SQL should be written as a single script that can be pasted into MySQL and run without edits. Make sure you use the proper notation for your...

How do you create indexes for these queries? What are the correct statements that will help the queries index correctly. We already created queries but we need help with indexing thanks! CREATE...

Create a new database and execute the code below in SQL Server's query window to create the database tables, CREATE TABLE Physician Specialties (Specialty.In integer, SpesialtyName varchar(5e),...

Step 1: Table Creation Create a new database and execute the code below in SQL Server's query window to create the database tables CREATE TABLE PhysicianSpecialties (Specialty integer, Sascialtxams,...

Example 2: Below are some queries about create table, drop or alter it, insert data into table, etc. Please read each part carefully then write and execute it in MS SQL server management studio. /*...

Which of the following tends to fall over time? Net profit margin Total asset turnover Retention ratio or Leverage None of the above

Find the amount and the compound interest on Rs. 1,00,000 compounded quarterly for 9 months at the rate of 4% per annum.

A government received insurance proceeds of $ 3 5 , 0 0 0 in the General Fund for water and smoke damage that occurred at City Hall. What journal entry best describes the accounting treatment in the...

Refer to the following CuNi isomorphous phase diagram, and answer question 1 . 1. A 60wt%Ni40wt% Cu alloy is slowly cooled from 1400C to 1200C. a. At what temperature does the first solid phase form?...

Explain the difference between Job Analysis, Job Classification, and Job Evaluation.

What does Processing of an OLAP Cube accomplish?

After designing a Multidimensional Database in Visual Studio, what are the next steps that build the Database in the Analysis Services Instance? How is the build out of the Analytical Services...