state stateCode CHAR(2) description VARCHAR (30) Indexes quarter qtrCode VARCHAR(5) location CHAR(2) minSal DECIMAL(6,2) minHrs TINYINT...

Transcribed Image Text:

state stateCode CHAR(2) description VARCHAR (30) Indexes quarter qtrCode VARCHAR(5) location CHAR(2) minSal DECIMAL(6,2) minHrs TINYINT Indexes AK AL AR AS AZ DESSERAHKAN FL FM Notes: This database is for tracking co-op opportunities. Table "quarter" holds information about what is desired. Table "interview" holds information about offers. GA Write a SQL statement that accomplishes a theoretical relational algebra difference between the state and quarter tables (STATE- QUARTER). Sort the output by statecode ascending order. Limit the output to 25 rows. Use the coding standards that were in Appendix A on HW02. statecode | GU HI IA ID IL IN KY LA MD ME companyName VARCHAR(30) division VARCHAR(30) address VARCHAR(30) city VARCHAR(20) stateCode CHAR(2) zipcode VARCHAR(10) Indexes MH interview InterviewID INT MI 25 rows in set (0.00 sec) interviewDate DATE companyName VARCHAR(30) division VARCHAR(30) qtrCode VARCHAR(5) salaryOffered DECIMAL(8,2) minHrsOffered TINYINT listing ENUM(Y', 'n') jobDesc VARCHAR(255) Indexes state stateCode CHAR(2) description VARCHAR (30) Indexes quarter qtrCode VARCHAR(5) location CHAR(2) minSal DECIMAL(6,2) minHrs TINYINT Indexes AK AL AR AS AZ DESSERAHKAN FL FM Notes: This database is for tracking co-op opportunities. Table "quarter" holds information about what is desired. Table "interview" holds information about offers. GA Write a SQL statement that accomplishes a theoretical relational algebra difference between the state and quarter tables (STATE- QUARTER). Sort the output by statecode ascending order. Limit the output to 25 rows. Use the coding standards that were in Appendix A on HW02. statecode | GU HI IA ID IL IN KY LA MD ME companyName VARCHAR(30) division VARCHAR(30) address VARCHAR(30) city VARCHAR(20) stateCode CHAR(2) zipcode VARCHAR(10) Indexes MH interview InterviewID INT MI 25 rows in set (0.00 sec) interviewDate DATE companyName VARCHAR(30) division VARCHAR(30) qtrCode VARCHAR(5) salaryOffered DECIMAL(8,2) minHrsOffered TINYINT listing ENUM(Y', 'n') jobDesc VARCHAR(255) Indexes