/media/sda-magnetic/david/Dok-15-2023-11-27/informatik/newC2023-10-23/c2023-10-23/php-sql-bash-exercise/2023-07-20/quantity.php

<?php 
include ("/home/david/db_settings.php");

$db = new PDO ("mysql: host=localhost", $MYSQL_USER, $MYSQL_PASSWORD);

$sql = "CREATE DATABASE q0003" . ($rnd = rand () % 2048);
$db->query ($sql);

$sql = "USE q0003" . $rnd;
$db->query ($sql);

$sql = "CREATE TABLE a (x INTEGER); CREATE TABLE b (x INTEGER); CREATE TABLE c (x INTEGER)";
$db->query ($sql);

for ($i = 0;  $i < 24;  $i++) {
    $sql = "INSERT INTO a (x) VALUES (" . rand () % 32 . "); ";
    $sql .= "INSERT INTO b (x) VALUES (" . rand () % 64 . "); ";
    $sql .= "INSERT INTO c (x) VALUES (" . rand () % 48 . "); ";
    $db->query ($sql);
}

$sql = "SELECT x FROM (SELECT x FROM a UNION SELECT x FROM b) x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br>\n";

$sql = "SELECT x FROM (SELECT x FROM a UNION SELECT x FROM c) x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br>\n";

$sql = "SELECT x FROM (SELECT x FROM b UNION SELECT x FROM c) x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br>\n";

$sql = "SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM b) x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br>\n";

$sql = "SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM c) x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br>\n";

$sql = "SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM c) x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br>\n";

$sql = "SELECT x FROM (
            SELECT x FROM (SELECT x FROM a UNION SELECT x FROM b) x
                INTERSECT
            SELECT x FROM c
    ) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br>\n";

$sql = "SELECT x FROM (
            SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM c) x
                UNION 
            SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM c) x
    ) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br>\n";

    
$sql = "SELECT x FROM (
            SELECT x FROM (SELECT x FROM a UNION SELECT x FROM c) x
                INTERSECT
            SELECT x FROM b
    ) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br>\n";

$sql = "SELECT x FROM (
            SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM b) x
                UNION 
            SELECT x FROM (SELECT x FROM c INTERSECT SELECT x FROM b) x
    ) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br>\n";

    
$sql = "SELECT x FROM (
            SELECT x FROM (SELECT x FROM b UNION SELECT x FROM c) x
                INTERSECT
            SELECT x FROM a
    ) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br>\n";

$sql = "SELECT x FROM (
            SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM a) x
                UNION 
            SELECT x FROM (SELECT x FROM c INTERSECT SELECT x FROM a) x
    ) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br>\n";

$db = null;
?>