• current year total job post mysql query?

    Answered

    current year total job post mysql query?

    Bronze Member Asked on March 30, 2017 in MYSQL.
    Add Comment
  • 2 Answer(s)
    Best answer
     SELECT MONTH( u.account_created_date )
     MONTH , u.user_id, u.first_name, COUNT( p.employer_id )
     FROM wl_users AS u
     LEFT JOIN wl_jobs AS p ON u.user_id = p.employer_id
     WHERE YEAR( u.account_created_date ) =2017
     AND u.user_type = 'employer'
     AND u.status = '1'
     GROUP BY u.user_id, u.first_name, DATE_FORMAT( u.account_created_date, "%m-%Y" )
     
    Bronze Member Answered on March 30, 2017.
    Add Comment
    
    SELECT u.user_id, u.first_name, COUNT( p.employer_id )
    
    FROM wl_users AS u
    
    LEFT JOIN wl_jobs AS p ON u.user_id = p.employer_id
    
    WHERE YEAR( p.last_repost_date ) =2017
    
    AND u.user_type = 'employer'
    
    AND u.status = '1'
    
    GROUP BY u.user_id, u.first_name,DATE_FORMAT( p.last_repost_date, "%m-%Y" )
    
    
    Bronze Member Answered on March 30, 2017.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.