DuckDB - первые впечатления - 4

SELECT 
    sw.* EXCLUDE (jar_jar_binks, midichlorians),
    ff.* EXCLUDE cancellation
FROM star_wars sw, firefly ff

SELECT 
    * REPLACE (movie_count+3 AS movie_count, show_count*1000 AS show_count)
FROM star_wars_owned_by_disney

SELECT
    systems,
    planets,
    cities,
    cantinas,
    SUM(scum + villainy) AS total_scum_and_villainy
FROM star_wars_locations
GROUP BY ALL

SELECT * EXCLUDE (cantinas, booths, scum, villainy),
    SUM(scum + villainy) AS total_scum_and_villainy
FROM star_wars_locations
GROUP BY ALL -- GROUP BY systems, planets, cities

SELECT
    age,
    SUM(civility) AS total_civility
FROM star_wars_universe
GROUP BY ALL
ORDER BY ALL -- ORDER BY age, total_civility

SELECT
    x_wing,
    proton_torpedoes,
    --targeting_computer
FROM luke_whats_wrong
GROUP BY
    x_wing,
    proton_torpedoes,

SELECT
    'Use the Force, Luke'[:13] AS sliced_quote_1,
    substr('I am your father', 1, 4) AS sliced_quote_2,
    SUBSTRING('Obi-Wan Kenobi, you''re my only hope',17,100) AS sliced_quote_3