Tables are as follows..

Clients
`ClientID` int(11) NOT NULL auto_increment,
`ClientName` varchar(50) collate latin1_general_ci default NULL,
`ClientEmail` varchar(50) collate latin1_general_ci NOT NULL default '',
`ClientPassword` varchar(10) collate latin1_general_ci NOT NULL default '',
`ClientTelNumber` varchar(20) collate latin1_general_ci default NULL,
`ClientCompanyInfo` text collate latin1_general_ci,
`ClientCountry` varchar(50) collate latin1_general_ci default NULL,
`ClientCity` varchar(50) collate latin1_general_ci default NULL,
`ClientAddress` varchar(250) collate latin1_general_ci default NULL,

SearchCodes
`SearchCodeID` int(11) NOT NULL auto_increment,
`SearchCode` varchar(25) NOT NULL default '',
`ReportCode` varchar(100) default NULL,
`ClientID` int(11) NOT NULL default '0',
`Price` float(9,2) default NULL,

Now I want to display those clients whose TotalPrice is greater than 1000;

I wrote this query.

select cl.ClientID, cl.ClientName, SUM(sc.Price) as Revenue from clients cl, searchcodes sc
WHERE cl.ClientID=sc.ClientID
GROUP BY cl.ClientID;

This query return ClientID, ClientName and the total revenue generated by this customer. Now I want to place a condition "If Revenue is greater than 1000"