1. You will need to use DBeaver with MariaDB/MySQL (XAMPP orGoogle), SQLite, and PostgreSQL.
2. In SQLite,MariaDB, and PostgreSQL create atable called date_dilemma with two fields as follows:
   1. fmt which contains text up to 25 characters in length
   2. a_date which is a DATE
3. The quiz consists of questions pairs. One part will askif a certain date format is accepted, and then the next questionwill as if it is output correctly.
4. For each question pair in the quiz you will write an insertstatement that inserts the formatted date, January 4, 2014, listedin the question. For example, the first row, '2014-01-04', would beinserted using INSERT INTO date_dilemmaVALUES ('''2014-01-04''', '2014-01-04'); You will do thisfor SQLite,MariaDB, and PostgreSQL. Fill inthe table for each insert.
5. Be careful with the lines that have quotes, you'll need toescape the single quotes so that should up inthe fmt field.
6. To test if it outputs correctly, you will use the followingqueries:
   1. SQLite: select fmt, a_date, strftime('%m', a_date) asmonth, strftime('%d', a_date) as day, strftime('%Y', a_date) asyear from date_dilemma;
   2. MariaDB/MySQL: select fmt, a_date, month(a_date) as month,day(a_date) as day, year(a_date) as year from date_dilemma;
   3. PostgreSQL: select fmt, a_date, date_part('month', a_date)as month, date_part('day', a_date) as day, date_part('year',a_date) as year from date_dilemma;