1. Find the bowlers who had a raw score of 165 or better at Thunderbird Lanes...

 

Transcribed Image Text:

1. "Find the bowlers who had a raw score of 165 or better at Thunderbird Lanes combined with bowlers who had a raw score of 150 or better at Bolero Lanes." (Hint: This is another of those problems that can also be solved with a single SELECT statement and a complex WHERE clause.) You can find the solution using UNION in CH10_Good_Bowlers_TBird_Bolero_ UNION (129 rows). You can find the solution using WHERE in CH10_Good_ Bowlers_TBird_ Bolero_WHERE (135 rows). 2. Can you explain why the row counts are different in the previous solution queries? (Hint: Try using UNION ALL in the first query.) 1. "Find the bowlers who had a raw score of 165 or better at Thunderbird Lanes combined with bowlers who had a raw score of 150 or better at Bolero Lanes." (Hint: This is another of those problems that can also be solved with a single SELECT statement and a complex WHERE clause.) You can find the solution using UNION in CH10_Good_Bowlers_TBird_Bolero_ UNION (129 rows). You can find the solution using WHERE in CH10_Good_ Bowlers_TBird_ Bolero_WHERE (135 rows). 2. Can you explain why the row counts are different in the previous solution queries? (Hint: Try using UNION ALL in the first query.)

Answer rating: 100% (QA)

SQL SELECT DISTINCTBBOWLERID BBOWLERLASTNAME BBOWLERFIRSTNAME AS GOOD ... View the full answer