1SELECT P.product_name, S.year, S.price FROM Sales S INNER JOIN Product P ON S.product_id = P.product_id;

1#include <unordered_map>
2#include <vector>
3#include <string>
4#include <iostream>
5using namespace std;

struct Sale {
    int sale_id;
    int product_id;
    int year;
    int quantity;
    int price;
};

struct Product {
    int product_id;
    string product_name;
};

struct Result {
    string product_name;
    int year;
    int price;
};

vector<Result> productSalesAnalysis(vector<Sale>& sales, vector<Product>& products) {
    unordered_map<int, string> productMap;
    for (const auto& product : products) {
        productMap[product.product_id] = product.product_name;
    }

    vector<Result> result;
    for (const auto& sale : sales) {
        if (productMap.find(sale.product_id) != productMap.end()) {
            result.push_back({productMap[sale.product_id], sale.year, sale.price});
        }
    }
    return result;
}

int main() {
    vector<Sale> sales = {
        {1, 100, 2008, 10, 5000},
        {2, 100, 2009, 12, 5000},
        {7, 200, 2011, 15, 9000}
    };

    vector<Product> products = {
        {100, "Nokia"},
        {200, "Apple"},
        {300, "Samsung"}
    };

    vector<Result> results = productSalesAnalysis(sales, products);
    for (const auto& result : results) {
        cout << result.product_name << " " << result.year << " " << result.price << endl;
    }
    return 0;
}