which shop has happy hour most frequently? List its id and number of happy hours.
CREATE TABLE happy_hour (
    shop_id VARCHAR
)
SELECT shop_id, COUNT(*) FROM happy_hour GROUP BY shop_id ORDER BY COUNT(*) DESC LIMIT 1
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: which shop has happy hour most frequently? List its id and number of happy hours. ### Input: CREATE TABLE happy_hour (
    shop_id VARCHAR
) ### Response: SELECT shop_id, COUNT(*) FROM happy_hour GROUP BY shop_id ORDER BY COUNT(*) DESC LIMIT 1