Data Viz and SQL

The name of this diagram is ..

• Barchart

• Histogram

• Lollipop

• Funnel Chart

What is True about COX Comb Chart

• Invented by a nurse name Florence Nightingale

• Another name is call Wild Rose Chart

• It used Pollar coordinate system

• Lead to Paracetamol Later

Which chart are applying Pollar Coordinate?

• Pie

• Waffle Chart

• Lolipop Chart

• Doughnut Chat

Which charts are good for visualizing trend?

• Barchart

• Line Chart

• Heatmap table

• Dengrogram

If we want to see how much of the total sales by product category? Which chart can be used?

• Bar chart

• Box Plot

• Treemap

• Lollipop Chart

What value Box plot do not tell us?

• median

• average

• 3rd quartile

• minimum

What is the join type in SQL?

• INNER JOIN

• LEFT JOIN

• UNION

• FULL OUTER JOIN

Which code are wrong?

• Average(sale) as Total_sales

• CASE WHEN Sales < 100 THEN 'LESS THAN 100' END as sales_group

• MAX(Sales) as Maximum_Sales

• SELECT TOP 10 CUSTOMER , SUM(Sales) as TOTAL_SALES FROM TRANSACTIONS;

Which are True about this Syntax?

• It 's good to go

• JOINING ARE WRONG

• CUSTOMER_ ID WILL BE ERROR

• ALL ARE INCORRECT

What is true about SELF JOIN ?

• Use the same table

• No ON for joining Table

• Require key on Joining

• Do not requite Aliase for table e.g. Transaction A , Transaction B