In Big Data, suppose we wanted to retrieve records of shifts worked on a weekend in 2020 or at all during 2021. Which of the following WHERE conditions would be correct? 1 WHERE s.dayofweek IN ('SA', 'SU') AND (DATE_FORMAT(es.wdate,'%Y') = '2020' OR DATE_FORMAT(es.wdate,'%Y') = '2021' ) 2 WHERE es.wdate IN ('2020', '2021') AND s.dayofweek IN ('SA', 'SU') 3 WHERE (s.dayofweek IN ('SA', 'SU') AND DATE_FORMAT(es.wdate,'%Y') = '2020') OR es.wdate LIKE '2021%' 4 WHERE s.dayofweek = SA OR SU AND DATE_FORMAT(es.wdate,'%Y') = '2020' OR DATE_FORMAT(es.wdate,'%Y') = '2021'
In Big Data, suppose we wanted to retrieve records of shifts worked on a weekend in 2020 or at all during 2021. Which of the following WHERE conditions would be correct? 1 WHERE s.dayofweek IN ('SA', 'SU') AND (DATE_FORMAT(es.wdate,'%Y') = '2020' OR DATE_FORMAT(es.wdate,'%Y') = '2021' ) 2 WHERE es.wdate IN ('2020', '2021') AND s.dayofweek IN ('SA', 'SU') 3 WHERE (s.dayofweek IN ('SA', 'SU') AND DATE_FORMAT(es.wdate,'%Y') = '2020') OR es.wdate LIKE '2021%' 4 WHERE s.dayofweek = SA OR SU AND DATE_FORMAT(es.wdate,'%Y') = '2020' OR DATE_FORMAT(es.wdate,'%Y') = '2021'
Chapter2: Database Design Fundamentals
Section: Chapter Questions
Problem 15RQ
Related questions
Question
In Big Data, suppose we wanted to retrieve records of shifts worked on a weekend in 2020 or at all during 2021. Which of the following WHERE conditions would be correct?
1 WHERE s.dayofweek IN ('SA', 'SU') AND (DATE_FORMAT(es.wdate,'%Y') = '2020' OR DATE_FORMAT(es.wdate,'%Y') = '2021' )
2 WHERE es.wdate IN ('2020', '2021') AND s.dayofweek IN ('SA', 'SU')
3 WHERE (s.dayofweek IN ('SA', 'SU') AND DATE_FORMAT(es.wdate,'%Y') = '2020') OR es.wdate LIKE '2021%'
4 WHERE s.dayofweek = SA OR SU AND DATE_FORMAT(es.wdate,'%Y') = '2020' OR DATE_FORMAT(es.wdate,'%Y') = '2021'
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
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
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
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