NFT 上架信息表 - `hts_item_detail` 查询和统计

To query the table 'hts_item_detail' and display the columns 'amount', 'list_end_time', 'owner_no', and 'event_id', while also counting the number of records, and sorting the 'amount' column in ascending order based on 'event_id' grouping, you can use the following SQL query:

SELECT amount, COUNT(*) AS count, list_end_time, owner_no, event_id
FROM hts_item_detail
GROUP BY event_id
ORDER BY event_id ASC, amount ASC;

This query will return the selected columns ('amount', 'list_end_time', 'owner_no', and 'event_id'), along with the count of records for each group of 'event_id'. The results will be sorted in ascending order based on 'event_id' and then 'amount'.