sql help

[pbalsamo]

I need to know if there is a better way of getting Customer by month and years in different rows

jan-dec 2008

jan-dec 2007

 

thanks

 

 

 

  

SELECT 'a' as Num, Count(Leads.City) as Amount, 'Jan' as SeqMonth FROM Leads WHERE EXTRACT(Month FROM Leads.Date) = 1 AND EXTRACT(Year FROM Leads.Date) = %s UNION SELECT 'b' as Num, Count(Leads.City) as Amount, 'Feb' as SeqMonth FROM Leads WHERE EXTRACT(Month From Leads.Date) = 2 AND EXTRACT(Year from Leads.Date) = %s UNION SELECT 'c' as Num, Count(Leads.City) as Amount, 'Mar' as SeqMonth FROM Leads WHERE EXTRACT(Month From Leads.Date) = 3 AND EXTRACT(Year from Leads.Date) = %s UNION SELECT 'd' as Num, Count(Leads.City) as Amount, 'Apr' as SeqMonth FROM Leads WHERE EXTRACT(Month From Leads.Date) = 4 AND EXTRACT(Year from Leads.Date) = %s UNION SELECT 'e' as Num, Count(Leads.City) as Amount, 'May' as SeqMonth FROM Leads WHERE EXTRACT(Month From Leads.Date) = 5 AND EXTRACT(Year from Leads.Date) = %s UNION SELECT 'f' as Num, Count(Leads.City) as Amount, 'Jun' as SeqMonth FROM Leads WHERE EXTRACT(Month From Leads.Date) = 6 AND EXTRACT(Year from Leads.Date) = %s UNION SELECT 'g' as Num, Count(Leads.City) as Amount, 'Jul' as SeqMonth FROM Leads WHERE EXTRACT(Month From Leads.Date) = 7 AND EXTRACT(Year from Leads.Date) = %s 

[gevans]

How is your table laid out??

[pbalsamo]

Table layout the num column is used so I can sort table

 

NUM  |  Amount | Month

a          8453        Jan

[fenway]

Don't double-post -- I already deleted a third thread of exactly the same topic.