期末复习5
# 决策树 1234567891. SELECT DISTINCT store_id FROM Tx WHERE month = 5;2. SELECT DISTINCT c.name FROM Tx t JOIN Tx_Cakes tc ON t.tx_id = tc.tx_idJOIN Cake c ON tc.cake_id = c.cake_id WHERE t.month = 5;3. SELECT t.month,SUM(t.value) AS total_value,AVG(t.value) AS avg_value,COUNT(tc.cake_id) AS...
more...