will wgopar

## MySQL_practice_problems.md

      
        
          
            
              
              1 file
            
          
          
            
              
              5 forks
            
          
          
            
              
              7 comments
            
          
          
            
              
              16 stars
            
          
        
        
          
              
          
          
            
                wgopar
                / MySQL_practice_problems.md
            
            
              Last active
              July 12, 2023 07:08
            
              
                MySQL Employees Sample Database exercise problems + solutions.
              
          
        
      
        
  
      
    MySQL practice problems using the Employees Sample Database along with my solutions. See here for database installation details.
Problem 1

Find the number of Male (M) and Female (F) employees in the database and order the counts in descending order.
SELECT gender, COUNT(*) AS total_count
FROM employees 
GROUP BY gender