<s>[INST] Write a SQL code to identify the number of shops for each unique point-of-sale (POS) end date.  [/INST] SELECT shop_pos_end_date, COUNT(*) AS total_shops_per_pos_end_date FROM order_transaction.transaction_detail_deprecated GROUP BY shop_pos_end_date; </s>