MySQL 8 Db Queries
Budget: $50 – $75 USD
Summary: MySQL 8 Community Server Database Project.
Table or View Needed: postal_met_4_analysis. This project involves complex queries that reads every row in a selected date range from the "postal_mailers_random" table and creates a View table that displays different aspects of "met_4". Functionality We need the option to enter a date range in a query to Select a date range with UK date format, yyyy-mm-dd to yyyy-mm-dd. [Example 2021-06-01 to 2021-10-11. ] Retrieve data from [postal_mailer_random] between the start date and end date criteria. Order data on met_4 field first, in ascending order, then date_eng_uk field second, in ascending order. Count each date [mailer_date] in [postal_mailer_random] table that [area_met_4] in [postal_met_static] table had mail-outs in the date range. The met_4 value " 8 " had mail to go out 15-times between 6/1/21 and 10/11/21. Count the number of days between each met_4 mail-out. Ex. Mail was sent out for met_4 value " 8 " on 6/4/22. The next time mail was sent out for met_4 value " 8 " was 22-days later on 6/26/21. For more details, please request PDF attachment.
Table or View Needed: postal_met_4_analysis. This project involves complex queries that reads every row in a selected date range from the "postal_mailers_random" table and creates a View table that displays different aspects of "met_4". Functionality We need the option to enter a date range in a query to Select a date range with UK date format, yyyy-mm-dd to yyyy-mm-dd. [Example 2021-06-01 to 2021-10-11. ] Retrieve data from [postal_mailer_random] between the start date and end date criteria. Order data on met_4 field first, in ascending order, then date_eng_uk field second, in ascending order. Count each date [mailer_date] in [postal_mailer_random] table that [area_met_4] in [postal_met_static] table had mail-outs in the date range. The met_4 value " 8 " had mail to go out 15-times between 6/1/21 and 10/11/21. Count the number of days between each met_4 mail-out. Ex. Mail was sent out for met_4 value " 8 " on 6/4/22. The next time mail was sent out for met_4 value " 8 " was 22-days later on 6/26/21. For more details, please request PDF attachment.