CSC 371 Lecture Notes - Lecture 18: Bubble Chart, Scatter Plot

• School: University of Victoria
• Department: Computer Science
• Course: CSC 371
• Professor: Alex Thomo

Document Summary

Sum(case when 0<=totalprice and totalprice<10 then 1 else 0 end) as cnt_0_10, Sum(case when 10<=totalprice and totalprice<100 then 1 else 0 end) as cnt_10_100, Sum(case when 100<=totalprice and totalprice<1000 then 1 else 0 end) as cnt_100_1000, Sum(case when 1000<=totalprice then 1 else 0 end) as cnt_1000, Order by 1: find the number of orders and population by state. Order by 2 desc: how many zipcodes have only one order, how many two orders, etc. Order by 1: chart the zipcodes in a map in excel. **scatter plot with x axis between 20 and 50 and y axis -135 and -65: chart the zipcodes in a map in excel; the zipcodes where solar power is used should be in different color. Select zipcode, longitude, (case when hhuofuelsolar = 0 then latitude end) as nosolarlat, (case when hhuofuelsolar > 0 then latitude end) as solarlat. Where latitude between 20 and 50 and longitude between -135 and -65;