-- Database schema
| member : Member_ID [ INT ] primary_key , Card_Number [ TEXT ] , Name [ TEXT ] , Hometown [ TEXT ] , Level [ INT ] | branch : Branch_ID [ INT ] primary_key , Name [ TEXT ] , Open_year [ TEXT ] , Address_road [ TEXT ] , City [ TEXT ] , membership_amount [ TEXT ] | membership_register_branch : Member_ID [ INT ] primary_key membership_register_branch.Member_ID = member.Member_ID , Branch_ID [ TEXT ] membership_register_branch.Branch_ID = branch.Branch_ID , Register_Year [ TEXT ] | purchase : Member_ID [ INT ] primary_key purchase.Member_ID = member.Member_ID , Branch_ID [ TEXT ] purchase.Branch_ID = branch.Branch_ID , Year [ TEXT ] , Total_pounds [ INT ] |
-- -- Show card number, name, and hometown for all members in a descending order of level.

SELECT card_number ,  name ,  hometown FROM member ORDER BY LEVEL DESC;