Can we write one query instead of following three query?

[sunil divyeshvar]

Hi all ,

I need to show such information on application report.

Information need to show like this:
------------------------------------------------------------------------------------
Property Avaialble :
Property Sold/Rent :
Property In process :
------------------------------------------------------------------------------------

For that we are using following three queries , is that possible to generate such type of information by executing only one query ?

SELECT COUNT(*) AS count FROM ATPROPERTIES.property_ptnf WHERE STATUS IN('Active','Back on Market','Contingent','New','Reactivated','Price Change') AND ZIP='60540';
----------------------------------------------------------------
SELECT COUNT(*) AS count FROM ATPROPERTIES.property_ptnf WHERE STATUS IN('Sold','Rented') AND ZIP='60540'AND SALEDATE >= (CURRENT_DATE - INTERVAL 90 day);
------------------------------------------------------------------
SELECT COUNT(*) AS count FROM ATPROPERTIES.property_ptnf WHERE STATUS IN('Pending') AND ZIP='60540';
---------------------------------------------------------------------



Thanks,