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