Lesson 2 Lab Questions

Using the project created in the first lab (Building Permits 2014) from the lesson 1 lab answer the following questions. Answer are provided for your reference in a separate page.


Question 1: How many projects exist for the postal code M1G?


Question 2: In the postal code M1G, how permits type are there for “Plumbing”?


Question 3: What is the longest text for “Structure_Type” and how many characters does it contains?


Question 4: How many conditional permit (permits type) have no structure type defined?


Question 5: What is the permit number of the oldest application?


Question 6: How much does the most expensive project cost?


Question 7: How many unique permit number there is new buildings (column work) only with more than 100 dwelling units


Question 8: When was the latest permit issued?


Question 9: Which day received the most applications


Question 10 : Look for the permit number 00 137770 CMB. Then sort by permit number (text a -z) and then with the lowest revision number first and reorder row permanently. What happen

Last modified: Friday, 18 September 2015, 1:37 PM