The program imports data in .csv format. It uses SQL SELECT command with two arguments, it asks the user if it is needed to group some of the data so it may use the COUNT and GROUP BY commands. After the new tables are created, it plots the data and prompts the user to give name to the plot and data.frame so they will be exported as jpeg and .csv respectively. At the end it asks if there are data that are not numeric so it plots a bar chart instead of line plot. (more…)