9924.sql

/*

Find libraries who haven't provided the email address in circulation year 2016 but their notice preference definition is set to email
https://platform.stratascratch.com/coding/9924-find-libraries-who-havent-provided-the-email-address-in-2016-but-their-notice-preference-definition-is-set-to-email?code_type=3


Difficulty: Easy

Find libraries who haven't provided the email address in circulation year 2016 but their notice preference definition is set to email.
Output the library code.

Tables:

<lyft_drivers>

| Column                            | Data Type  |
|-----------------------------------|------------|
| patron_type_code                  | int        |
| patron_type_definition            | varchar    |
| total_checkouts                   | int        |
| total_renewals                    | int        |
| age_range                         | varchar    |
| home_library_code                 | varchar    |
| home_library_definition           | varchar    |
| circulation_active_month          | varchar    |
| circulation_active_year           | float      |
| notice_preference_code            | varchar    |
| notice_preference_definition      | varchar    |
| provided_email_address            | bool       |
| year_patron_registered            | int        |
| outside_of_county                 | bool       |
| supervisor_district               | float      |


*/

select DISTINCT home_library_code 
from library_usage
where notice_preference_definition = "email" && provided_email_address = "true";