Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following database: Customer Customid - FirstName - LastName 200 Ali Salim 201 Musallam Ahmad 202 Muna Khalaf Sector GroupID Business GR-101 Information Technologies
Consider the following database: Customer Customid - FirstName - LastName 200 Ali Salim 201 Musallam Ahmad 202 Muna Khalaf Sector GroupID Business GR-101 Information Technologies Gr-100 Academia Gr-103 Level VIP Group GroupID - GroupName. Inauguratior GR-100 12/9/2007 GR-101 Gold 1/22/2006 GR-102 Silver 1/22/2006 Gr-103 Bronz 6/3/2003 1 2 3 3 Write the SQL query to give the list of groups having customers from Academia but not from Business
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