{ "text":"Write SQL statements to satisfy the following information requests",
"connection":"sql_book_connection",
"diagram":"hudson-sales",
"schema":"hudsonu",
"owner":"hudsonu",
"scoreVisibility":["student","professor"],
"tasks":[{
"text":"Create a list of customers ordered by last name. include each customer’s first and last name.",
"start":"",
"key":["SELECT first_name, last_name from customer ORDER BY last_name;"],
"lines":5,
"points":10
},{
"text":"Create a list of possible combinations of product graphic types and seasons. Order by the season. Include the graphic type and season code.",
"start":"",
"key":["SELECT DISTINCT graphic_type, season_code from product ORDER BY season_code;"],
"lines":5,
"points":10
},{
"text":"Create a list of unique product categories and subcategories combinations. Order by category then subcategory. Include the category and subcategory in the final list.",
"start":"",
"key":["SELECT DISTINCT category, subcategory from product ORDER BY category, subcategory;"],
"lines":5,
"points":10
},{
"text":"Create a list of vendors. Order by the vendor's state and then by their phone number. In the final list, include the vendor name, state, phone number, and fax number.",
"start":"",
"key":["SELECT name, state, phone, fax from vendor ORDER BY state, phone;"],
"lines":5,
"points":10
},{
"text":"Create a list of vendors again. Order the list in reverse alphabetical order. Include all vendor information.",
"start":"",
"key":["SELECT * from vendor ORDER BY name DESC;"],
"lines":5,
"points":10
},{
"text":"Create a list of the different quantities present in all sales and order by quantity in ascending order. The final list should just include the quantity. ",
"start":"",
"key":["SELECT DISTINCT qty from sale_product ORDER BY qty;"],
"lines":5,
"points":10
},{
"text":"Create a product list from most expensive to least expensive. If multiple products have the same price, sort alphabetically by the product name. Include the product name and the price.",
"start":"",
"key":["SELECT name, current_price FROM product ORDER BY current_price DESC, name;"],
"lines":5,
"points":10
},{
"text":"Create a list of unique product fabric and fit combinations. Order first by fit by reverse alphabetical order then by fabric in reverse alphabetical order. Include the fabric and fit columns. ",
"start":"",
"key":["SELECT DISTINCT fabric, fit FROM product ORDER BY fit DESC, fabric DESC;"],
"lines":5,
"points":10
},{
"text":"Retrieve the region table. Order alphabetically by state code, region, and then division. Include all columns in the region table.",
"start":"",
"key":["SELECT * FROM region ORDER BY state_code, region, division;"],
"lines":5,
"points":10
},{
"text":"Retrieve the region table. Order alphabetically by division, region, and then state code. Include all columns in the region table.",
"start":"",
"key":["SELECT * FROM region ORDER BY division, region, state_code;"],
"lines":5,
"points":10
}]
}
"connection":"sql_book_connection",
"diagram":"hudson-sales",
"schema":"hudsonu",
"owner":"hudsonu",
"scoreVisibility":["student","professor"],
"tasks":[{
"text":"Create a list of customers ordered by last name. include each customer’s first and last name.",
"start":"",
"key":["SELECT first_name, last_name from customer ORDER BY last_name;"],
"lines":5,
"points":10
},{
"text":"Create a list of possible combinations of product graphic types and seasons. Order by the season. Include the graphic type and season code.",
"start":"",
"key":["SELECT DISTINCT graphic_type, season_code from product ORDER BY season_code;"],
"lines":5,
"points":10
},{
"text":"Create a list of unique product categories and subcategories combinations. Order by category then subcategory. Include the category and subcategory in the final list.",
"start":"",
"key":["SELECT DISTINCT category, subcategory from product ORDER BY category, subcategory;"],
"lines":5,
"points":10
},{
"text":"Create a list of vendors. Order by the vendor's state and then by their phone number. In the final list, include the vendor name, state, phone number, and fax number.",
"start":"",
"key":["SELECT name, state, phone, fax from vendor ORDER BY state, phone;"],
"lines":5,
"points":10
},{
"text":"Create a list of vendors again. Order the list in reverse alphabetical order. Include all vendor information.",
"start":"",
"key":["SELECT * from vendor ORDER BY name DESC;"],
"lines":5,
"points":10
},{
"text":"Create a list of the different quantities present in all sales and order by quantity in ascending order. The final list should just include the quantity. ",
"start":"",
"key":["SELECT DISTINCT qty from sale_product ORDER BY qty;"],
"lines":5,
"points":10
},{
"text":"Create a product list from most expensive to least expensive. If multiple products have the same price, sort alphabetically by the product name. Include the product name and the price.",
"start":"",
"key":["SELECT name, current_price FROM product ORDER BY current_price DESC, name;"],
"lines":5,
"points":10
},{
"text":"Create a list of unique product fabric and fit combinations. Order first by fit by reverse alphabetical order then by fabric in reverse alphabetical order. Include the fabric and fit columns. ",
"start":"",
"key":["SELECT DISTINCT fabric, fit FROM product ORDER BY fit DESC, fabric DESC;"],
"lines":5,
"points":10
},{
"text":"Retrieve the region table. Order alphabetically by state code, region, and then division. Include all columns in the region table.",
"start":"",
"key":["SELECT * FROM region ORDER BY state_code, region, division;"],
"lines":5,
"points":10
},{
"text":"Retrieve the region table. Order alphabetically by division, region, and then state code. Include all columns in the region table.",
"start":"",
"key":["SELECT * FROM region ORDER BY division, region, state_code;"],
"lines":5,
"points":10
}]
}