Solved by Expert Tutors
This is from the University of Auckland Infosys 222. I've been having issues with 4 of the questions. This is the 3rd one I'm having trouble with.
Solved by Expert Tutors
Question

Hello! This is from the University of Auckland Infosys 222. I've been

having issues with 4 of the questions. This is the 3rd
one I'm having trouble with. Any directionally-correct ideas to help me start on this is helpful and valued or links that may help with what kind of steps I need to make. Thanks!
===


QUESTION DIAGRAM:
This is a diagram of the tables that is provided for us to look at to make the SQL code. We don't have actual data this time - just this mock-up so we know what the table structure and relationships are like:

QUESTION:


Among all draws in 2019, how often is the winning power ball an even number? What SQL statement would list all the draw records in 2019 with an even power ball number by projecting three columns, drawNo, drawDate and pbNo? Order the list by drawDate in descending order. You must provide all relevant logics and/or assumptions you have applied as part of the answer for your SQL statement in order to obtain any mark.
--


Do you have any ideas for me on this one? Thanks so much!

LottoSQL.png

Step-by-step answer

itur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vita


sus ante,

ctum vitae odio. Donec aliq

dictum v

m risus ante, dapibus a molestie consequat, ultri

Donec aliquet. Lorem

acinia pulvi

, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapib


pulvinar tort

ec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a

rem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar

cing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet

amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pell

lestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facili

a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel

, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit a



pulvinar tor

Subscribe to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question