/******************************************************************************/
/*																				                                    */
/*	Kroenke, Auer, Vandenberg, and Yoder 					*/
/*	Database Concepts (8th Edition) Appendix E 	       		*/
/*																			                                     	*/
/*	Wedgewood Pacific [WP] Exercises for Appendix E  		*/
/*																				                                    */
/*	This is the Oracle Express 11g Release 2 code  							            */
/*																				                                    */
/******************************************************************************/

/****** FOR SOLUTIONS TO E.55, E.56, and E.57:  see the following files:  ******/

/*  DBC-e08-ODB-WP-Insert-Data-AppE.sql				*/

/*  DBC-e08-ODB-WP-Create-AppE-Tables.sql				*/

/******   Exercise E.58  ************************************/

SELECT SKU, CatalogDescription, CatalogPage, DateOnWebSite
FROM CATALOG_SKU_2016
	UNION
SELECT SKU, CatalogDescription, CatalogPage, DateOnWebSite
FROM CATALOG_SKU_2017
ORDER BY SKU;

							
/******   Exercise E.59  ************************************/	

SELECT SKU, CatalogDescription, CatalogPage, DateOnWebSite
FROM CATALOG_SKU_2015
	UNION
SELECT SKU, CatalogDescription, CatalogPage, DateOnWebSite
FROM CATALOG_SKU_2016
	UNION
SELECT SKU, CatalogDescription, CatalogPage, DateOnWebSite
FROM CATALOG_SKU_2017
ORDER BY SKU;

/******************************************************************************/
