<s>[INST] Write a SQL code to count the total number of unique shop IDs in the database.  [/INST] SELECT COUNT(DISTINCT shop_id) AS total_unique_shop_ids FROM order_transaction.transaction_detail_deprecated; </s>