{ "text":"Congratulations! You have been promoted to Assistant to the Regional Manager at the local Hudson University Bookstore. Your duties include the following:",
"connection":"sql_book_connection",
"diagram":"hudson-sales",
"schema":"hudsonu",
"owner":"hudsonu",
"scoreVisibility":["student","professor"],
"tasks":[{
"text":"The bookstore wants to impliment a new marketing strategy personalized to each customer. To do so, create a list of customers. Show the customers' first and last names.",
"start":"",
"key":["SELECT first_name, last_name from customer"],
"lines":5,
"points":10
},{
"text":"Tax season is approaching and you have been assigned the task of generating a tax report. To comply with financial reporting requirements and fulfill tax obligations, the report needs to include the sale ID and tax amount for each transaction.",
"start":"",
"key":["SELECT sale_id , tax from sale"],
"lines":5,
"points":10
},{
"text":"The bookstore is starting an analysis on where customers are coming from based on region. To start the analysis, retrieve the region table. Include all columns in the region table.",
"start":"",
"key":["SELECT * from region"],
"lines":5,
"points":10
},{
"text":"For an inventory report, create a list of vendor IDs with at least one product in the store. Include the vendor ID.",
"start":"",
"key":["SELECT DISTINCT vendor_ID from product"],
"lines":5,
"points":10
},{
"text":"To gain insights on the geographical distribution of customers for the new marketing strategy, create a list of unique region, division, and state combinations where customers are from. Include the region, division, and state code.",
"start":"",
"key":["SELECT DISTINCT region, division, state_code FROM region"],
"lines":5,
"points":10
},{
"text":"As part of a vendor management initiative at the bookstore, you have been asked to create an information sheet for the first 10 vendors. This sheet should include comprehensive details about each vendor.",
"start":"",
"key":["SELECT * FROM vendor LIMIT 10;"],
"lines":5,
"points":10
},{
"text":"As part of a vendor management initiative at the bookstore, you have been asked to create an information sheet for the second 10 vendors. This sheet should include comprehensive details about each vendor.",
"start":"",
"key":["SELECT * FROM vendor LIMIT 10 OFFSET 10;"],
"lines":5,
"points":10
},{
"text":"The Regional Manager looked at your reports but can't tell which report is for which task. Recreate the last question but comment the question on two lines before the query. Use the “/*” and “*/” comment method.",
"start":"",
"key":["/*Create a vendor list with all the vendor information but only show results for the second 10 vendors.*/ SELECT * FROM vendor LIMIT 10 OFFSET 10;"],
"lines":5,
"points":10
},{
"text":"The new marketing strategy includes a raffle prize drawing. Find the winner of the raffle by creating the list of customers again (from question 1) but this time comment on the line below the query the first and last name of the customer from line 1. Use the “#” comment method.",
"start":"",
"key":["SELECT first_name, last_name from customer #Martie Feasby"],
"lines":5,
"points":10
},{
"text":"Continue the region report from question 3 by finding how many regions a customer could be from. In the first line of the query, comment how many rows are in the region table using the “--” method. Include all columns in the region table.",
"start":"",
"key":["SELECT * from region --50"],
"lines":5,
"points":10
}]
}
"connection":"sql_book_connection",
"diagram":"hudson-sales",
"schema":"hudsonu",
"owner":"hudsonu",
"scoreVisibility":["student","professor"],
"tasks":[{
"text":"The bookstore wants to impliment a new marketing strategy personalized to each customer. To do so, create a list of customers. Show the customers' first and last names.",
"start":"",
"key":["SELECT first_name, last_name from customer"],
"lines":5,
"points":10
},{
"text":"Tax season is approaching and you have been assigned the task of generating a tax report. To comply with financial reporting requirements and fulfill tax obligations, the report needs to include the sale ID and tax amount for each transaction.",
"start":"",
"key":["SELECT sale_id , tax from sale"],
"lines":5,
"points":10
},{
"text":"The bookstore is starting an analysis on where customers are coming from based on region. To start the analysis, retrieve the region table. Include all columns in the region table.",
"start":"",
"key":["SELECT * from region"],
"lines":5,
"points":10
},{
"text":"For an inventory report, create a list of vendor IDs with at least one product in the store. Include the vendor ID.",
"start":"",
"key":["SELECT DISTINCT vendor_ID from product"],
"lines":5,
"points":10
},{
"text":"To gain insights on the geographical distribution of customers for the new marketing strategy, create a list of unique region, division, and state combinations where customers are from. Include the region, division, and state code.",
"start":"",
"key":["SELECT DISTINCT region, division, state_code FROM region"],
"lines":5,
"points":10
},{
"text":"As part of a vendor management initiative at the bookstore, you have been asked to create an information sheet for the first 10 vendors. This sheet should include comprehensive details about each vendor.",
"start":"",
"key":["SELECT * FROM vendor LIMIT 10;"],
"lines":5,
"points":10
},{
"text":"As part of a vendor management initiative at the bookstore, you have been asked to create an information sheet for the second 10 vendors. This sheet should include comprehensive details about each vendor.",
"start":"",
"key":["SELECT * FROM vendor LIMIT 10 OFFSET 10;"],
"lines":5,
"points":10
},{
"text":"The Regional Manager looked at your reports but can't tell which report is for which task. Recreate the last question but comment the question on two lines before the query. Use the “/*” and “*/” comment method.",
"start":"",
"key":["/*Create a vendor list with all the vendor information but only show results for the second 10 vendors.*/ SELECT * FROM vendor LIMIT 10 OFFSET 10;"],
"lines":5,
"points":10
},{
"text":"The new marketing strategy includes a raffle prize drawing. Find the winner of the raffle by creating the list of customers again (from question 1) but this time comment on the line below the query the first and last name of the customer from line 1. Use the “#” comment method.",
"start":"",
"key":["SELECT first_name, last_name from customer #Martie Feasby"],
"lines":5,
"points":10
},{
"text":"Continue the region report from question 3 by finding how many regions a customer could be from. In the first line of the query, comment how many rows are in the region table using the “--” method. Include all columns in the region table.",
"start":"",
"key":["SELECT * from region --50"],
"lines":5,
"points":10
}]
}