Q1: What is wrong with this query? Based on context, AND should be “WHERE”. SELECT tableA.columnA FROM tableA AND tableA.columnA IS NOT NULL Q2: What does this query do? Pulls data from Column A and Column B from Table A where Column A is not blank/null, and where Column B IS blank/null. It will be ordered by the first column in the table and limited to the first 100 results. I would personally use Select top 100 instead as I use SSMS and Data Studio, not MySQL. SELECT tableA.columnA FROM tableA WHERE tableA.columnA IS NOT NULL AND tableA.columnB IS NULL ORDER BY 1 LIMIT 100 Q3: What does this query do? Selects all null a_id from tableA and the left join will show if there are any matching null a_id in tableB in the second column of query results. SELECT count(*) AS cnt FROM tableA LEFT JOIN tableB ON tableA.id = tableB.a_id WHERE tableB.a_id IS NULL Asurion_P ublic PART TWO: DATA ANALYSIS AND VISUALIZATION EXERCISE Instructions: Use the Excel dataset called ‘Sample Repair Data_2022’ to answer the following. Conduct your analysis in Power BI and present your findings using PowerPoint slides. Q1: Which three stores have struggled the most with same-day completion in 2021? Note: ‘same_day_completion’ is marked with a “1” on workorders that were completed same day. Q2: Technicians are expected to work quickly but also produce high quality repairs. Identify a technician who you might consider interviewing to understand best practices. I’ll need to create a new measure before determining this. Note: Turn-around time (TAT) measures the number of hours between the time a repair is started and the time it is completed. ‘ubif_90_bounce’ is flagged with a “1” for repairs that failed within 90 days and required rework. Q3: A member of our operations team will be visiting with the manager of the Citrus Heights store this week. To help prepare for the visit, prepare some visualizations to help this colleague understand: a. How total sales is trending in August b. One other topic of your choice