Question
2.56 Write an SQL statement to display the SKU, SKU_Description, and Department of all SKUs that appear in either the Cape Codd 2013 catalog (either
2.56 Write an SQL statement to display the SKU, SKU_Description, and Department of all SKUs that appear in either the Cape Codd 2013 catalog (either in the printed catalog or on the Web site) or the Cape Codd 2014 catalog (either in the printed catalog or on the Web site) or both.
2.57 Write an SQL statement to display the SKU, SKU_Description, and Department of all SKUs that appear in either the Cape Codd 2013 catalog (only in the printed catalog itelf) or the Cape Codd 2014 catalog (only in the printed catalog itself) or both.
2.58 Write an SQL statement to display the SKU, SKU_Description, and Department of all SKUs that appear in both the Cape Codd 2013 catalog (either in the printed catalog or on the Web site) and the Cape Codd 2014 catalog (either in the printed catalog or on the Web site).
2.59 Write an SQL statement to display the SKU, SKU_Description, and Department of all SKUs that appear in both the Cape Codd 2013 catalog (only in the printed catalog itelf) and the Cape Codd 2014 catalog (only in the printed catalog itself) or both.
2.60 Write an SQL statement to display the SKU, SKU_Description, and Department of all SKUs that appear in only the Cape Codd 2013 catalog (either in the printed catalog or on the Web site) and not in the Cape Codd 2014 catalog (either in the printed catalog or on the Web site).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Modern Database Management
Authors: Donald A. Carpenter Fred R. McFadden
1st Edition
8178088045, 978-8178088044
