Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Single Table Query Assignment House 4.2 Section Review 1. Create SQL queries to extract the following from the house table, whose metadata is shown Table: house column name data type size notes about the data ID Тext house ID number (primary key) street Тext 40 street address city Text 20 state Тext 2 zip Тext 5 5-digit zip codes only bedrooms Number number of bedrooms; integer bathrooms Number number of bathrooms; could end in .5 value Number appraised value or sale price of house first Text 20 first name of the listing or selling agent last name of the listing or selling agent true = sold ; false = not sold last Text 20 sold Boolean Figure 4-7: metadata for a table of houses. in Figure 4-7: a. The House ID, street address, and value for houses in the 19140 zip code under $240,000. b. The House ID, street address, and value for houses in the 19128 zip code with at least three bedrooms and two bathrooms. c. The House ID, street address, zip code and value for houses sold by Mark Jones. d. The street address, value, number of bedrooms and number of bathrooms for houses in the 19116 and 19154 zip codes. e. The House ID, street address and value for houses in the 19139 zip code that have not been sold.

Single Table Query Assignment House 4.2 Section Review 1. Create SQL queries to extract the following from the house table, whose metadata is shown Table: house column name data type size notes about the data ID Тext house ID number (primary key) street Тext 40 street address city Text 20 state Тext 2 zip Тext 5 5-digit zip codes only bedrooms Number number of bedrooms; integer bathrooms Number number of bathrooms; could end in .5 value Number appraised value or sale price of house first Text 20 first name of the listing or selling agent last name of the listing or selling agent true = sold ; false = not sold last Text 20 sold Boolean Figure 4-7: metadata for a table of houses. in Figure 4-7: a. The House ID, street address, and value for houses in the 19140 zip code under $240,000. b. The House ID, street address, and value for houses in the 19128 zip code with at least three bedrooms and two bathrooms. c. The House ID, street address, zip code and value for houses sold by Mark Jones. d. The street address, value, number of bedrooms and number of bathrooms for houses in the 19116 and 19154 zip codes. e. The House ID, street address and value for houses in the 19139 zip code that have not been sold.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

How can I write a SQL script for those spicific taskes that mentioned in the picture?

 

 

Single Table Query Assignment House 4.2 Section Review 1. Create SQL queries to extract the following from the house table, whose metadata is shown Table: house column name data type size notes about the data ID Text house ID number (primary key) street Text 40 street address city Text 20 state Тext 2 5-digit zip codes only number of bedrooms; integer zip Тext bedrooms Number bathrooms Number number of bathrooms; could end in .5 value Number appraised value or sale price of house first Тext 20 first name of the listing or selling agent last Text 20 last name of the listing or selling agent sold Boolean true = sold ; false = not sold Figure 4-7: metadata for a table of houses. in Figure 4-7: а. The House ID, street address, and value for houses in the 19140 zip code under $240,000. b. The House ID, street address, and value for houses in the 19128 zip code with at least three bedrooms and two bathrooms. The House ID, street address, zip code and value for houses sold by Mark Jones. c. d. The street address, value, number of bedrooms and number of bathrooms for houses in the 19116 and 19154 zip codes. The House ID, street address and value for houses in the 19139 zip code that e. have not been sold.
Transcribed Image Text:Single Table Query Assignment House 4.2 Section Review 1. Create SQL queries to extract the following from the house table, whose metadata is shown Table: house column name data type size notes about the data ID Text house ID number (primary key) street Text 40 street address city Text 20 state Тext 2 5-digit zip codes only number of bedrooms; integer zip Тext bedrooms Number bathrooms Number number of bathrooms; could end in .5 value Number appraised value or sale price of house first Тext 20 first name of the listing or selling agent last Text 20 last name of the listing or selling agent sold Boolean true = sold ; false = not sold Figure 4-7: metadata for a table of houses. in Figure 4-7: а. The House ID, street address, and value for houses in the 19140 zip code under $240,000. b. The House ID, street address, and value for houses in the 19128 zip code with at least three bedrooms and two bathrooms. The House ID, street address, zip code and value for houses sold by Mark Jones. c. d. The street address, value, number of bedrooms and number of bathrooms for houses in the 19116 and 19154 zip codes. The House ID, street address and value for houses in the 19139 zip code that e. have not been sold.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS