SQL Query #1: Show the student_id (parking_permits), last name (members), first name (members) phone (members), plate number, vehicle make, vehicle model, vehicle type where the school year is 15-16 Note that you are not required to show the year in the result grid, however, you may want to include it when you develop the query to make sure you are getting the correct results.

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
icon
Related questions
icon
Concept explainers
Question

Computer science 

SQL Query #1:
Show the student_id (parking_permits), last name (members), first name (members) phone (members), plate number,
vehicle make, vehicle model, vehicle type where the school year is 15-16
Note that you are not required to show the year in the result grid, however, you may want to include it when you
develop the query to make sure you are getting the correct results.
SCHEMAS
Filter objects
▾ college
Tables
ē=====ŠPODO
advisors
members
parking permits
scholarships
scholarships_students
Views
parking permits 15-16
parking_permits_16-17
students_city_tpelkie
students_scholarships_tp
Stored Procedures
Functions
collegebak
sakila
sys
test
world
1.
2
Result Grid
student_id
1 60 61 62 68 0 乃乃花 鸡
70
73
74
76
| ZIA
SELECT * FROM college.`parking_permits_15-16`;
79
Filter Rows:
Iname
fname
Lee
Emma
Goldstein Huah
Eckert Katie
Berauin Marianne
McElanev Cleta
Ibtehal Ahiamu
Hardv
Caitlvn
Nicole
Dutton
Elraheb
Stephan
Lisa
Sharpe
Limit to 1000 rows
Wrap Cell Content: IA
phone
plate_number vehicle_make
619-222-0123 KoolGRL
Mazda
619-583-8789 8ABC123
619-585-3267 4JST234
619-297-4255 897X765
619-604-5858 7MZY224
858-677-6531 6FGH850
619-685-3699 1L8796
619-687-3872 8X98543
619-670-5143 HOTHERE
619-733-4877 LUV2RUN
Tovota
Honda
Dodge
Ford
Ford
BMW
Chevrolet
Subaru
Kia
Export:
vehicle_model
Mazda3
Camrv
Civic
Ram
Fiesta
Explorer
K1300GT
Silverado
Forester
Optima
vehicle_type
car
car
car
truck
car
car
motorcycle
truck
car
car
Transcribed Image Text:SQL Query #1: Show the student_id (parking_permits), last name (members), first name (members) phone (members), plate number, vehicle make, vehicle model, vehicle type where the school year is 15-16 Note that you are not required to show the year in the result grid, however, you may want to include it when you develop the query to make sure you are getting the correct results. SCHEMAS Filter objects ▾ college Tables ē=====ŠPODO advisors members parking permits scholarships scholarships_students Views parking permits 15-16 parking_permits_16-17 students_city_tpelkie students_scholarships_tp Stored Procedures Functions collegebak sakila sys test world 1. 2 Result Grid student_id 1 60 61 62 68 0 乃乃花 鸡 70 73 74 76 | ZIA SELECT * FROM college.`parking_permits_15-16`; 79 Filter Rows: Iname fname Lee Emma Goldstein Huah Eckert Katie Berauin Marianne McElanev Cleta Ibtehal Ahiamu Hardv Caitlvn Nicole Dutton Elraheb Stephan Lisa Sharpe Limit to 1000 rows Wrap Cell Content: IA phone plate_number vehicle_make 619-222-0123 KoolGRL Mazda 619-583-8789 8ABC123 619-585-3267 4JST234 619-297-4255 897X765 619-604-5858 7MZY224 858-677-6531 6FGH850 619-685-3699 1L8796 619-687-3872 8X98543 619-670-5143 HOTHERE 619-733-4877 LUV2RUN Tovota Honda Dodge Ford Ford BMW Chevrolet Subaru Kia Export: vehicle_model Mazda3 Camrv Civic Ram Fiesta Explorer K1300GT Silverado Forester Optima vehicle_type car car car truck car car motorcycle truck car car
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Query Syntax
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.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education