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 4th 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 4th 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:

What SQL statement would produce a view named RecentDraws that shows the detail of the last 4 draws with ten columns: drawNo, drawDate, n1, n2, n3, n4, n5, n6, pbNo and revenue? It is assumed that each line of a ticket generates $1.5 of revenue. For presentation purpose, the value of the column revenue is formatted with a leading dollar sign. 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.
-
What ideas do you have for me on this one? Thanks so much for all of your guidance!

LottoSQL.png

Step-by-step answer

rem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequ

risus

at, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dict

facilisi

onec aliquet. Lorem

inia pulvinar tortor nec facilisis. Pellentesque

ia pulvinar tortor nec facilisis. Pellentesque

ctum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetu

or nec facilisis. Pellentesque dap

acinia pulvi

sum do


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, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odi

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

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