Import avocado.csv The dataset contains avocado sales data from 2015 to 2018 2. Querying data (5 points, 0.5 point each) Once you have finished importing the database, write queries that extract following information. Your queries should extract the answers directly. If you need additional step (e.g., hand counting the number of rows) to get the answer after running a query, the query is not considered as the right query for the question. Copy and paste your queries and result table to Word and submit it in class. Write queries to extract following information: 1. Which day was the conventional avocado sold the most at Boston? Please show the date together with total volume. 2. Which day was the organic avocado sold at the highest price at Seattle? Please show the date together with average price. 3. How many days was the organic avocado sold at an average price greater than 1.5 in TotalUs? 4. How many distinct regions was the avocado sold at in 2015 in this table? 5. What was the average price of avocado in TotalUS each year? Please show average price together with year. 6. Which (month year) was the avocado sold at the highest price in Atlanta? Please show (month, year) together with the average price. 7. Which year was the organic avocado sold the most in TotalUS? Please show the year together with volume. 8. How much conventional avocado was sold in 2017? 9. Which region was the organic avocado sold the least in? Please show the region together with volume. 10. Which regions have average price of conventional avocado higher than 1.3? Please show the regions together with average price in descending order of average price. Import avocado.csv The dataset contains avocado sales data from 2015 to 2018 2. Querying data (5 points, 0.5 point each) Once you have finished importing the database, write queries that extract following information. Your queries should extract the answers directly. If you need additional step (e.g., hand counting the number of rows) to get the answer after running a query, the query is not considered as the right query for the question. Copy and paste your queries and result table to Word and submit it in class. Write queries to extract following information: 1. Which day was the conventional avocado sold the most at Boston? Please show the date together with total volume. 2. Which day was the organic avocado sold at the highest price at Seattle? Please show the date together with average price. 3. How many days was the organic avocado sold at an average price greater than 1.5 in TotalUs? 4. How many distinct regions was the avocado sold at in 2015 in this table? 5. What was the average price of avocado in TotalUS each year? Please show average price together with year. 6. Which (month year) was the avocado sold at the highest price in Atlanta? Please show (month, year) together with the average price. 7. Which year was the organic avocado sold the most in TotalUS? Please show the year together with volume. 8. How much conventional avocado was sold in 2017? 9. Which region was the organic avocado sold the least in? Please show the region together with volume. 10. Which regions have average price of conventional avocado higher than 1.3? Please show the regions together with average price in descending order of average price
