Basic Accounts Query:
Show query statements
<h3>List of Basic packages<h3>
select c.cid,count(c.cid) as "Number of packages",c.emailaddress,c.date from accounts a,customers c where a.cid=c.cid and ( a.pid=4 or a.pid=5 or a.pid=6 ) and a.suspend!="Y" group by c.cid order by c.cid