This project required me to create a database, insert data and categorise it using GROUP BY, HAVING, AND and OR functions in SQLite. I used a future store sales database to inquire highly popular payment types per country. The below picture is the database schema creation and insertion of rows.
Next step was to view all the data in a user friendly table using AS function.
My final step was to use the CASE function on my database. I made a case for a highly popular payment type to have more than 15 transaction amounts and an average payment type to have less than 10 transaction amounts. I then grouped the data by country and payment type. The result shows that a highly popular payment type in the US is Visa.