how to – Get count of multiple table records with group by function
I have 2 tables :
I want to get the following data in a single row:
1) Sum of these 2 table records
2) Count of individual table records
3) Count of priority_list_delete table records category wise
This is what I have done so far:
SELECT (SELECT COUNT(*) FROM priority_list)+(SELECT COUNT(*) from priority_list_delete) as tot_count, (SELECT COUNT(*) FROM priority_list) as prior_cnt, (SELECT COUNT(*) FROM priority_list_delete) as prior_del_cnt
The above query returns the count of the tables but when I merge the below query with the above one, it throws an error:
(SELECT category, COUNT(*) FROM priority_list_delete group by category)
I guess, there is some syntax error which I am unable to sort it out and moreover I am not getting idea about how to get the count records category wise where category names will be the column name.
tot_count| prior_cnt| prior_del_cnt| ST | OBC ---------|----------|--------------|------|------ 920 | 893 | 27 | 64 | 100
Here ST and OBC are the categories.
Any help would be appreciated.
Thanks in advance.