SQL Assignment help | Practice Set

Tables

Leads (Lead_ID, Created_Date, Lead_Owner)

Accounts (Account_ID, Created_Date, Revenue_Target, Industry, Acc_Owner)

Opportunities (Opportunity_ID, Created_Date, Stage, Opportunity_Bookings, Opp_Owner, Account_ID,

Lead_ID)

Q1. What was the total number of leads created in April by ‘Jane Smith’?

Q2. What is the total number of opportunities created per industry? Sort from lowest to highest

Q3. How many opportunities with Stage as ‘Open’ do the accounts in ‘Automotive’ industry have?

Q4. What are the total bookings ‘Closed Won’ by each owner for all leads created after August 1st?

Q5. Assuming a lead was created first, what is the average time between opportunity creation and lead

creation for each industry? Sort by highest to lowest average time

Q6. Please answer the following questions in a structured way (Maximum 1 page in total in Word for the

2 questions)

• What was the most complex dashboard/data visualization you built? Should include at least: Audience, Goal, Why it was complex, Impact/use of the dashboard

• Describe a situation where you had to deal with and resolve data issues (e.g. Data inaccuracy, instability, data quality)