CIS - Basic Queries Assessment

xlsx

School

Arizona State University *

*We aren’t endorsed by this school

Course

105

Subject

Computer Science

Date

Dec 6, 2023

Type

xlsx

Pages

3

Uploaded by AmbassadorSquid3849

Report
Useful Links Query 1 To enter a data.world query, select C10 and paste it into the formula bar. Query 2 To enter a data.world query, select C15 and paste it into the formula bar. Query 3 To enter a data.world query, select C20 and paste it into the formula bar. Query 4 To enter a data.world query, select C25 and paste it into the formula bar. Open data.world query editor Show database diagram for these queries SELECT episode, title, air_date FROM episode ORDER BY title SELECT episode, title, rating FROM episode ORDER BY rating DESC, title ASC SELECT DISTINCT character FROM character_award ORDER BY character SELECT DISTINCT name FROM person ORDER BY name LIMIT 20
Query 5 To enter a data.world query, select C30 and paste it into the formula bar. Query 6 To enter a data.world query, select C35 and paste it into the formula bar. Query 7 To enter a data.world query, select C40 and paste it into the formula bar. Query 8 To enter a data.world query, select C45 and paste it into the formula bar. Query 9 To enter a data.world query, select C50 and paste it into the formula bar. SELECT nickname, name FROM person ORDER BY nickname LIMIT 10 SELECT DISTINCT credit.person, credit.episode_id, credit.role From credit ORDER BY person SELECT DISTINCT award_category FROM award ORDER BY award_category SELECT vote.episode_id, stars, vote.votes FROM vote ORDER BY vote.votes DESC LIMIT 1
Query 10 To enter a data.world query, select C55 and paste it into the formula bar. SELECT vote.episode_id, vote.votes FROM vote ORDER BY vote.votes DESC LIMIT 1 SELECT organization, year, award_category, award FROM award ORDER BY year DESC LIMIT 1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

lab04-sol.pdf
08-04_task.docx
08-01_task.docx
Chapter 3 Assignment.docx
ITM-301 Lab 5 Fall 2023.docx
HW4.ipynb - Colaboratory.pdf
09 Indexes-Key (2).docx
MID TERM ASSESSMENT.docx
08 Normalization I - key.docx
08 Normalization II -Key.docx
CIS_2550_Topic6_Lab.docx
CIS_2550_Topic10_Lab complete (1).docx
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
SEE MORE TEXTBOOKS