Database

SELECT * FROM
 (
	SELECT C.ClientID, ClientName, StatusDescription, 
	CASE WHEN SM.StatusID IS NOT NULL THEN 'Y' ELSE 'N' END AS Actual
	FROM @Clients C
	LEFT OUTER JOIN @Statuses S ON C.ClientID = S.ClientID
	LEFT OUTER JOIN @StatusMappings SM on SM.StatusID = S.StatusID
) qry
PIVOT 
(
	MAX(Actual) FOR StatusDescription in ([Draft Letter],[Awaiting Response],[Complete])
) pvt
WHERE ClientName = 'Barclays'

EXTRACT(MONTH FROM VISIT_DATE) AS DAY_

EXTRACT(DAY FROM VISIT_DATE) AS DAY_

SELECT SUM(VISIT_FEE) AS FEE,
    EXTRACT(YEAR FROM VISIT_DATE) AS YEAR_,
    EXTRACT(MONTH FROM VISIT_DATE) AS MONTH_,
    EXTRACT(DAY FROM VISIT_DATE) AS DAY_
FROM MZS_VISIT_REQUEST
WHERE IS_PAY = 1
GROUP BY EXTRACT(YEAR FROM VISIT_DATE),
    EXTRACT(MONTH FROM VISIT_DATE) ,
    EXTRACT(DAY FROM VISIT_DATE)

SELECT
sum(VISIT_FEE) AS VISIT_FEE,
    EXTRACT(YEAR FROM VISIT_DATE) AS YEAR_,
    EXTRACT(MONTH FROM VISIT_DATE) AS MONTH_,

 
FROM
    MZS_VISIT_REQUEST
WHERE
    IS_PAY = 1
GROUP by
EXTRACT(YEAR FROM VISIT_DATE) AS YEAR_,
    EXTRACT(MONTH FROM VISIT_DATE) AS MONTH_

Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS AYEAR_,<br />
    EXTRACT(MONTH FROM VISIT_DATE) AS BMONTH_' at line 10

<br />
SELECT<br />
        SUM(VISIT_FEE) AS FEE,<br />
    EXTRACT(YEAR FROM VISIT_DATE) AS YEAR_,<br />
    EXTRACT(MONTH FROM VISIT_DATE) AS MONTH_<br />
FROM<br />
    MZS_VISIT_REQUEST<br />
WHERE<br />
    IS_PAY = 1 AND DISTINCT MONTH_<br />