Question: Given the three tables, write out what you think the output would be if the SQL code were executed. Refer to this tutorial (https://mode.com/sql-tutorial/sql-case/) to

Given the three tables, write out what you think the output would be if the SQL code were executed.

Refer to this tutorial (https://mode.com/sql-tutorial/sql-case/) to understand how to interpret CASE statements.

User ID 1 2 3 email john@gmail.com tom@gmail.com sarah@gmail.com nicole@gmail.com tim@gmail.com name john tom sarah nicole time 4 5 Devices ID 1 2 3 4 5 User_id 3 3 1 desc mobile macbook mobile pc mobile active yes yes no 4 no 4 yes File ID 1 2 3 4 5 User_id 3 3 3 4 4 File_type photo doc Mp3 photo photo File_name Selfie.jpg Todo.docx Song 1.mp3 Vacation 1.jpg Vacation2.jpg 3. = SELECT ID, CASE When File_type = 'photo' Then 'Photo' When File_type = "MP3' Then 'Not Photo' Else 'Not photo nor MP3 End as File_type From File 4. SELECT User.ID, User Name, Device.desc, CASE WHEN Device.desc = 'mobile' Then 'It's a mobile WHEN Device.desc = 'macbook' Then 'It's a macbook' ELSE 'Not mobile nor macbook' END as Device Text FROM User Join Device On user.ID = Device.user_id User ID 1 2 3 email john@gmail.com tom@gmail.com sarah@gmail.com nicole@gmail.com tim@gmail.com name john tom sarah nicole time 4 5 Devices ID 1 2 3 4 5 User_id 3 3 1 desc mobile macbook mobile pc mobile active yes yes no 4 no 4 yes File ID 1 2 3 4 5 User_id 3 3 3 4 4 File_type photo doc Mp3 photo photo File_name Selfie.jpg Todo.docx Song 1.mp3 Vacation 1.jpg Vacation2.jpg 3. = SELECT ID, CASE When File_type = 'photo' Then 'Photo' When File_type = "MP3' Then 'Not Photo' Else 'Not photo nor MP3 End as File_type From File 4. SELECT User.ID, User Name, Device.desc, CASE WHEN Device.desc = 'mobile' Then 'It's a mobile WHEN Device.desc = 'macbook' Then 'It's a macbook' ELSE 'Not mobile nor macbook' END as Device Text FROM User Join Device On user.ID = Device.user_id

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 Accounting Questions!

Given the three tables, write out what you think the output would be if the SQL code were executed. User ID 1 2 3 email john@gmail.com tom@gmail.com sarah@gmail.com nicole@gmail.com tim@gmail.com...

What were the top crime categories in 2014? How many incidences per category? What day of the week was there the most crime? What districts had the most crime incidences? . Where is the most...

Computer Organization and Networks Practicals 2021/22 October 9, 2021 Computer Organization and Networks Practicals 2021/22 b68495714b Contents Contents 0 Introduction 3 0.1 Registration . . . . . ....

Complete class diagram (phase 5 and 6). 17 Questions. 17 To be submitted: 18 Marking Criteria. 20 Appendix A: Sample Output for a completed phase 6. 22 Objectives In this assignment you will develop...

1. Daniel Dimwit sees an advertisement for a toaster oven at Target for the price of $49.00. When he gets to Target they are all sold out. Sears has the same toaster oven for $60.00. Can Mr. Dimwit...

ADMN 233 Assignment 4 Assignment 4 Instructions Assignment 4 is worth 20% of your final mark. It should be completed and submitted after you finish Chapter 13 in your textbook. This assignment is...

this is a python program please can anyone help me thank you Introduction In problem set 5, you will build a program to monitor news feeds over the Internet. Your program will filter the news,...

Introduction and learning objectives When you were learning about operational analysis earlier in the term, we talked about jobs that require multiple visits to the CPU (or servers) to receive their...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

First of all, have a look at the SQL database creation and population code that accompanies this assignment. All questions and items in this assignment pertain to the SQL code that accompanies this...

The press release referenced in the previous exercise also included data from independent surveys of teenage drivers and parents of teenage drivers. In response to a question asking if they approved...

One Laptop per Child Nicholas Negroponte is the founder of the MIT Media Lab and has spent his career pushing the edge of the information revolution as an inventor, thinker, and angel investor. His...

Key information for a compary is shown below. Total Assets: $ 9 0 million Total Liabilities: $ 4 0 milion Total Equity: $ 5 0 million Beta = 1 . 2 Current Price of Stock = $ 4 2 . 2 5 per share Bond...

Explaining the Early Laws in Civilized History Up To the Present. Include in your writings the manner in which laws were developed in Civilization and how these laws dealt with victims.

Consider a die-rolling experiment with events A, E1, E2, and E3 given by the following: A = 32, 4, 64 E1 = 31, 24 E2 = 33, 44 E3 = 35, 64 Show that E1 > A, E2 > A, and E3 > A are mutually exclusive...

3.119 You are responsible for detecting the source of the error when a computer system fails. From your analysis you know that the source of error is the disk drive, the computer memory, or the...

Consider a die-rolling experiment with A = 32, 4, 64 and B = 34, 5, 64. Show the following: a. (ANB) U (ANB) = B b. AU (ANB) = AUB