Practice Interview Questions
| Question | Status |
|---|---|
Opensea wants to analyze their sales data to identify the most expensive Non-Fungible Tokens (NFTs) sold in the past 30 days. Assume that today is April 15th, 2023.
Create a SQL query to find the top 3 most expensive NFTs sold during this period, along with their respective sale price. Assume that each NFT has a unique sale price.
nft_sales table:
| Column Name | Description |
|---|---|
| id | Unique identifier for each NFT sale |
| name | Name of the NFT |
| price | Sale price of the NFT |
| buyer_id | Identifier for the buyer |
| seller_id | Identifier for the seller |
Opensea wants to analyze their sales data to identify the most expensive Non-Fungible Tokens (NFTs) sold in the past 30 days. Assume that today is April 15th, 2023.
Create a SQL query to find the top 3 most expensive NFTs sold during this period, along with their respective sale price. Assume that each NFT has a unique sale price.
nft_sales table:
| Column Name | Description |
|---|---|
| id | Unique identifier for each NFT sale |
| name | Name of the NFT |
| price | Sale price of the NFT |
| buyer_id | Identifier for the buyer |
| seller_id | Identifier for the seller |
| date_of_sale | Time the NFT was sold |
| name | price |
|---|---|
| Mutant Ape | 25000 |
| CyberPunk | 19000 |
| Azuki | 15000 |
| date_of_sale | Time the NFT was sold |
| name | price |
|---|---|
| Mutant Ape | 25000 |
| CyberPunk | 19000 |
| Azuki | 15000 |