Could you please tell me all the catalog publishers whose name contains "Murray"?
select distinct ( catalog_publisher ) from catalogs where catalog_publisher like "%murray%"
What is the name of that catalog?
select catalog_name from catalogs where catalog_publisher like "%murray%"
What are the dates of latest revision for those?
select date_of_latest_revision from catalogs where catalog_publisher like "%murray%"
Could you please tell me all the catalog publishers whose name contains "chocolate"?
select catalog_publisher from catalogs where catalog_publisher like "%chocolate%"
How many catalogs do they publish?
select count ( * ) from catalogs where catalog_publisher in ( select distinct ( catalog_publisher ) from catalogs where catalog_publisher like "%chocolate%" )
What's the name of that catalog and its date of publication?
select catalog_name,date_of_publication from catalogs where catalog_publisher in ( select distinct ( catalog_publisher ) from catalogs where catalog_publisher like "%chocolate%" )