title: MySQL query for converting Date (mm-dd-yyyy) to a day of the week of a 3 months data (MySQL Workbench)
body: <p>From a supermarket Q1 sales data, <strong>I have to extract the highest number of sales by each of the days of the week (Sat,Sun,Mon,etc.).</strong> The table is an imported CSV file. It has <strong>'date'</strong> column given with &quot;mm-dd-yyyy&quot; format. I also want to know how to import the CSV correctly on MySQL Workbench as I have added the date column as <strong>'datetime'</strong> but no idea how to proceed. Here's the DDL I copied from the schema:</p>
  <pre><code>CREATE TABLE `supermarket_sales` (   
  `Invoice ID` text,   
  `Branch` text,   
  `City` text,   
  `Customer type` text,   
  `Gender` text,  
  `Product line` text,   
  `Unit price` double DEFAULT NULL,   
  `Quantity` int DEFAULT NULL,   
  `Tax 5%` double DEFAULT NULL,   
  `Total` double DEFAULT NULL,   
  `Date` datetime DEFAULT NULL,   
  `Time` text,  
  `Payment` text,   
  `cogs` double DEFAULT NULL,   
  `gross margin percentage` double DEFAULT NULL,   
  `gross income` double DEFAULT NULL,
  `Rating` double DEFAULT NULL 
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  </code></pre>