nick@Vaxis:~$ ssh artemis Linux artemis 4.19.0-18-amd64 #1 SMP Debian 4.19.208-1 (2021-09-29) x86_64 The programs included with the Debian GNU/Linux system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright. Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law. Last login: Thu Mar 16 11:03:35 2023 from 136.168.35.3 nick@artemis:~$ cd 3420/company/s23 nick@artemis:~/3420/company/s23$ mysql companys23; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A BWelcome to the MariaDB monitor. Commands end with ; or \g. BBYour MariaDB connection id is 31814 Server version: 10.3.36-MariaDB-0+deb10u2 Debian 10 BBCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. BBType 'help;' or '\h' for help. Type '\c' to clear the current input statement. BMariaDB [companys23]> show tables; +----------------------+ | Tables_in_companys23 | +----------------------+ | Department | | DepartmentLocations | | Dependent | | Employee | | Project | | WorksOn | +----------------------+ B6 rows in set (0.000 sec) BB BMariaDB [companys23]> describe Project; +-----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+----------------+ | Pnumber | int(11) | NO | PRI | NULL | auto_increment | | Pname | varchar(20) | YES | | NULL | | | Plocation | varchar(20) | YES | | NULL | | | Dnumber | int(11) | YES | MUL | NULL | | +-----------+-------------+------+-----+---------+----------------+ B4 rows in set (0.001 sec) BB BMariaDB [companys23]> select * from Department; +---------+----------------------+-------------+------------+ | Dnumber | Dname | Mgr_SSN | Mgr_start | +---------+----------------------+-------------+------------+ | 1 | Engineering | 250-42-9823 | 2021-11-01 | | 2 | Human Resources | 252-70-1281 | 2004-07-03 | | 3 | Sales | 626-86-0981 | 2010-12-26 | | 4 | R&D | 521-40-4757 | 2005-01-05 | | 5 | Business Development | 259-69-3521 | 2016-08-02 | | 6 | Marketing | 218-15-2428 | 2003-06-19 | +---------+----------------------+-------------+------------+ B6 rows in set (0.000 sec) BB BMariaDB [companys23]> insert into Project (Pname, Plocation, Dnumber) values ("Project X", "Warehouse", 1); BQuery OK, 1 row affected (0.001 sec) BB BMariaDB [companys23]> insert into Project (Pname, Plocation, Dnumber) values ("Zillenial"Outreac3);se", 1); BQuery OK, 1 row affected (0.001 sec) BB BMariaDB [companys23]> insert into Project (Pname, Plocation, Dnumber) valuNowher4);ettProjectillenial Outreach", 3); BQuery OK, 1 row affected (0.001 sec) BB BMariaDB [companys23]> insert into Project (Pname, Plocation, Dnumber) valuesWastecHRtHQmeject", "Nowhere"2);); BQuery OK, 1 row affected (0.001 sec) BB BMariaDB [companys23]> select * from Project; +---------+----------------+--------------------+---------+ | Pnumber | Pname | Plocation | Dnumber | +---------+----------------+--------------------+---------+ | 1 | Project X | Warehouse | 1 | | 2 | Project Y | Zillenial Outreach | 3 | | 3 | Secret Project | Nowhere | 4 | | 4 | Waste of Time | HR HQ | 2 | +---------+----------------+--------------------+---------+ B4 rows in set (0.000 sec) BB BMariaDB [companys23]> select * from WorksOn; BEmpty set (0.000 sec) BB BMariaDB [companys23]> describe WorksOn; +---------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+----------+------+-----+---------+-------+ | SSN | char(11) | NO | PRI | NULL | | | Pnumber | int(11) | NO | PRI | NULL | | | Hours | float | YES | | NULL | | +---------+----------+------+-----+---------+-------+ B3 rows in set (0.001 sec) BB BMariaDB [companys23]> select SSN, Pnumber from Employee JOIN Project; +-------------+---------+ | SSN | Pnumber | +-------------+---------+ | 157-88-7908 | 1 | | 157-88-7908 | 4 | | 157-88-7908 | 2 | | 157-88-7908 | 3 | | 169-88-1613 | 1 | | 169-88-1613 | 4 | | 169-88-1613 | 2 | | 169-88-1613 | 3 | | 178-09-9074 | 1 | | 178-09-9074 | 4 | | 178-09-9074 | 2 | | 178-09-9074 | 3 | | 180-68-1912 | 1 | | 180-68-1912 | 4 | | 180-68-1912 | 2 | | 180-68-1912 | 3 | | 252-70-1281 | 1 | | 252-70-1281 | 4 | | 252-70-1281 | 2 | | 252-70-1281 | 3 | | 356-90-7571 | 1 | | 356-90-7571 | 4 | | 356-90-7571 | 2 | | 356-90-7571 | 3 | | 357-26-8858 | 1 | | 357-26-8858 | 4 | | 357-26-8858 | 2 | | 357-26-8858 | 3 | | 369-50-5680 | 1 | | 369-50-5680 | 4 | | 369-50-5680 | 2 | | 369-50-5680 | 3 | | 375-34-0891 | 1 | | 375-34-0891 | 4 | | 375-34-0891 | 2 | | 375-34-0891 | 3 | | 486-81-9989 | 1 | | 486-81-9989 | 4 | | 486-81-9989 | 2 | | 486-81-9989 | 3 | | 526-92-5991 | 1 | | 526-92-5991 | 4 | | 526-92-5991 | 2 | | 526-92-5991 | 3 | | 532-76-3517 | 1 | | 532-76-3517 | 4 | | 532-76-3517 | 2 | | 532-76-3517 | 3 | | 536-16-5537 | 1 | | 536-16-5537 | 4 | | 536-16-5537 | 2 | | 536-16-5537 | 3 | | 543-29-8929 | 1 | | 543-29-8929 | 4 | | 543-29-8929 | 2 | | 543-29-8929 | 3 | | 596-37-9209 | 1 | | 596-37-9209 | 4 | | 596-37-9209 | 2 | | 596-37-9209 | 3 | | 615-18-6818 | 1 | | 615-18-6818 | 4 | | 615-18-6818 | 2 | | 615-18-6818 | 3 | | 622-30-0735 | 1 | | 622-30-0735 | 4 | | 622-30-0735 | 2 | | 622-30-0735 | 3 | | 645-74-0526 | 1 | | 645-74-0526 | 4 | | 645-74-0526 | 2 | | 645-74-0526 | 3 | | 665-86-8548 | 1 | | 665-86-8548 | 4 | | 665-86-8548 | 2 | | 665-86-8548 | 3 | | 850-85-0292 | 1 | | 850-85-0292 | 4 | | 850-85-0292 | 2 | | 850-85-0292 | 3 | | 855-68-5051 | 1 | | 855-68-5051 | 4 | | 855-68-5051 | 2 | | 855-68-5051 | 3 | | 134-43-6596 | 1 | | 134-43-6596 | 4 | | 134-43-6596 | 2 | | 134-43-6596 | 3 | | 155-65-2686 | 1 | | 155-65-2686 | 4 | | 155-65-2686 | 2 | | 155-65-2686 | 3 | | 206-42-6778 | 1 | | 206-42-6778 | 4 | | 206-42-6778 | 2 | | 206-42-6778 | 3 | | 259-69-3521 | 1 | | 259-69-3521 | 4 | | 259-69-3521 | 2 | | 259-69-3521 | 3 | | 311-57-2543 | 1 | | 311-57-2543 | 4 | | 311-57-2543 | 2 | | 311-57-2543 | 3 | | 442-52-4791 | 1 | | 442-52-4791 | 4 | | 442-52-4791 | 2 | | 442-52-4791 | 3 | | 467-54-3176 | 1 | | 467-54-3176 | 4 | | 467-54-3176 | 2 | | 467-54-3176 | 3 | | 533-85-8477 | 1 | | 533-85-8477 | 4 | | 533-85-8477 | 2 | | 533-85-8477 | 3 | | 581-28-8564 | 1 | | 581-28-8564 | 4 | | 581-28-8564 | 2 | | 581-28-8564 | 3 | | 688-21-1512 | 1 | | 688-21-1512 | 4 | | 688-21-1512 | 2 | | 688-21-1512 | 3 | | 785-69-1449 | 1 | | 785-69-1449 | 4 | | 785-69-1449 | 2 | | 785-69-1449 | 3 | | 803-13-5063 | 1 | | 803-13-5063 | 4 | | 803-13-5063 | 2 | | 803-13-5063 | 3 | | 851-37-9880 | 1 | | 851-37-9880 | 4 | | 851-37-9880 | 2 | | 851-37-9880 | 3 | | 221-78-4352 | 1 | | 221-78-4352 | 4 | | 221-78-4352 | 2 | | 221-78-4352 | 3 | | 224-05-5365 | 1 | | 224-05-5365 | 4 | | 224-05-5365 | 2 | | 224-05-5365 | 3 | | 259-67-9909 | 1 | | 259-67-9909 | 4 | | 259-67-9909 | 2 | | 259-67-9909 | 3 | | 368-34-7197 | 1 | | 368-34-7197 | 4 | | 368-34-7197 | 2 | | 368-34-7197 | 3 | | 414-10-4271 | 1 | | 414-10-4271 | 4 | | 414-10-4271 | 2 | | 414-10-4271 | 3 | | 463-13-5723 | 1 | | 463-13-5723 | 4 | | 463-13-5723 | 2 | | 463-13-5723 | 3 | | 521-52-7799 | 1 | | 521-52-7799 | 4 | | 521-52-7799 | 2 | | 521-52-7799 | 3 | | 575-99-3134 | 1 | | 575-99-3134 | 4 | | 575-99-3134 | 2 | | 575-99-3134 | 3 | | 632-84-2428 | 1 | | 632-84-2428 | 4 | | 632-84-2428 | 2 | | 632-84-2428 | 3 | | 663-54-0337 | 1 | | 663-54-0337 | 4 | | 663-54-0337 | 2 | | 663-54-0337 | 3 | | 717-85-9172 | 1 | | 717-85-9172 | 4 | | 717-85-9172 | 2 | | 717-85-9172 | 3 | | 725-13-9144 | 1 | | 725-13-9144 | 4 | | 725-13-9144 | 2 | | 725-13-9144 | 3 | | 769-08-1237 | 1 | | 769-08-1237 | 4 | | 769-08-1237 | 2 | | 769-08-1237 | 3 | | 801-55-5158 | 1 | | 801-55-5158 | 4 | | 801-55-5158 | 2 | | 801-55-5158 | 3 | | 827-84-9853 | 1 | | 827-84-9853 | 4 | | 827-84-9853 | 2 | | 827-84-9853 | 3 | | 829-82-9898 | 1 | | 829-82-9898 | 4 | | 829-82-9898 | 2 | | 829-82-9898 | 3 | | 831-68-7820 | 1 | | 831-68-7820 | 4 | | 831-68-7820 | 2 | | 831-68-7820 | 3 | | 861-96-0479 | 1 | | 861-96-0479 | 4 | | 861-96-0479 | 2 | | 861-96-0479 | 3 | | 108-30-6419 | 1 | | 108-30-6419 | 4 | | 108-30-6419 | 2 | | 108-30-6419 | 3 | | 199-45-7914 | 1 | | 199-45-7914 | 4 | | 199-45-7914 | 2 | | 199-45-7914 | 3 | | 279-97-0698 | 1 | | 279-97-0698 | 4 | | 279-97-0698 | 2 | | 279-97-0698 | 3 | | 476-67-1971 | 1 | | 476-67-1971 | 4 | | 476-67-1971 | 2 | | 476-67-1971 | 3 | | 489-86-9980 | 1 | | 489-86-9980 | 4 | | 489-86-9980 | 2 | | 489-86-9980 | 3 | | 519-28-6669 | 1 | | 519-28-6669 | 4 | | 519-28-6669 | 2 | | 519-28-6669 | 3 | | 521-40-4757 | 1 | | 521-40-4757 | 4 | | 521-40-4757 | 2 | | 521-40-4757 | 3 | | 548-58-9075 | 1 | | 548-58-9075 | 4 | | 548-58-9075 | 2 | | 548-58-9075 | 3 | | 608-12-4879 | 1 | | 608-12-4879 | 4 | | 608-12-4879 | 2 | | 608-12-4879 | 3 | | 626-86-0981 | 1 | | 626-86-0981 | 4 | | 626-86-0981 | 2 | | 626-86-0981 | 3 | | 640-78-3450 | 1 | | 640-78-3450 | 4 | | 640-78-3450 | 2 | | 640-78-3450 | 3 | | 658-02-8079 | 1 | | 658-02-8079 | 4 | | 658-02-8079 | 2 | | 658-02-8079 | 3 | | 730-73-1824 | 1 | | 730-73-1824 | 4 | | 730-73-1824 | 2 | | 730-73-1824 | 3 | | 735-36-0902 | 1 | | 735-36-0902 | 4 | | 735-36-0902 | 2 | | 735-36-0902 | 3 | | 740-55-0204 | 1 | | 740-55-0204 | 4 | | 740-55-0204 | 2 | | 740-55-0204 | 3 | | 788-79-8433 | 1 | | 788-79-8433 | 4 | | 788-79-8433 | 2 | | 788-79-8433 | 3 | | 852-63-0193 | 1 | | 852-63-0193 | 4 | | 852-63-0193 | 2 | | 852-63-0193 | 3 | | 112-77-5572 | 1 | | 112-77-5572 | 4 | | 112-77-5572 | 2 | | 112-77-5572 | 3 | | 218-15-2428 | 1 | | 218-15-2428 | 4 | | 218-15-2428 | 2 | | 218-15-2428 | 3 | | 250-42-9823 | 1 | | 250-42-9823 | 4 | | 250-42-9823 | 2 | | 250-42-9823 | 3 | | 250-86-3243 | 1 | | 250-86-3243 | 4 | | 250-86-3243 | 2 | | 250-86-3243 | 3 | | 327-45-5907 | 1 | | 327-45-5907 | 4 | | 327-45-5907 | 2 | | 327-45-5907 | 3 | | 407-66-4296 | 1 | | 407-66-4296 | 4 | | 407-66-4296 | 2 | | 407-66-4296 | 3 | | 439-93-4732 | 1 | | 439-93-4732 | 4 | | 439-93-4732 | 2 | | 439-93-4732 | 3 | | 440-89-5164 | 1 | | 440-89-5164 | 4 | | 440-89-5164 | 2 | | 440-89-5164 | 3 | | 645-89-3504 | 1 | | 645-89-3504 | 4 | | 645-89-3504 | 2 | | 645-89-3504 | 3 | | 649-68-0970 | 1 | | 649-68-0970 | 4 | | 649-68-0970 | 2 | | 649-68-0970 | 3 | | 720-58-9192 | 1 | | 720-58-9192 | 4 | | 720-58-9192 | 2 | | 720-58-9192 | 3 | | 799-59-0118 | 1 | | 799-59-0118 | 4 | | 799-59-0118 | 2 | | 799-59-0118 | 3 | | 195-36-4688 | 1 | | 195-36-4688 | 4 | | 195-36-4688 | 2 | | 195-36-4688 | 3 | | 248-16-5831 | 1 | | 248-16-5831 | 4 | | 248-16-5831 | 2 | | 248-16-5831 | 3 | | 250-45-6366 | 1 | | 250-45-6366 | 4 | | 250-45-6366 | 2 | | 250-45-6366 | 3 | | 301-24-1567 | 1 | | 301-24-1567 | 4 | | 301-24-1567 | 2 | | 301-24-1567 | 3 | | 310-24-7033 | 1 | | 310-24-7033 | 4 | | 310-24-7033 | 2 | | 310-24-7033 | 3 | | 447-39-2466 | 1 | | 447-39-2466 | 4 | | 447-39-2466 | 2 | | 447-39-2466 | 3 | | 449-14-0909 | 1 | | 449-14-0909 | 4 | | 449-14-0909 | 2 | | 449-14-0909 | 3 | | 484-58-1616 | 1 | | 484-58-1616 | 4 | | 484-58-1616 | 2 | | 484-58-1616 | 3 | | 508-50-6186 | 1 | | 508-50-6186 | 4 | | 508-50-6186 | 2 | | 508-50-6186 | 3 | | 515-40-9765 | 1 | | 515-40-9765 | 4 | | 515-40-9765 | 2 | | 515-40-9765 | 3 | | 554-96-0793 | 1 | | 554-96-0793 | 4 | | 554-96-0793 | 2 | | 554-96-0793 | 3 | | 575-99-5872 | 1 | | 575-99-5872 | 4 | | 575-99-5872 | 2 | | 575-99-5872 | 3 | | 600-82-6063 | 1 | | 600-82-6063 | 4 | | 600-82-6063 | 2 | | 600-82-6063 | 3 | | 609-89-7019 | 1 | | 609-89-7019 | 4 | | 609-89-7019 | 2 | | 609-89-7019 | 3 | | 676-04-3191 | 1 | | 676-04-3191 | 4 | | 676-04-3191 | 2 | | 676-04-3191 | 3 | | 755-49-5779 | 1 | | 755-49-5779 | 4 | | 755-49-5779 | 2 | | 755-49-5779 | 3 | | 862-55-5133 | 1 | | 862-55-5133 | 4 | | 862-55-5133 | 2 | | 862-55-5133 | 3 | | 874-24-1805 | 1 | | 874-24-1805 | 4 | | 874-24-1805 | 2 | | 874-24-1805 | 3 | | 893-15-9265 | 1 | | 893-15-9265 | 4 | | 893-15-9265 | 2 | | 893-15-9265 | 3 | +-------------+---------+ B400 rows in set (0.001 sec) BB BMariaDB [companys23]> select * from Project; +---------+----------------+--------------------+---------+ | Pnumber | Pname | Plocation | Dnumber | +---------+----------------+--------------------+---------+ | 1 | Project X | Warehouse | 1 | | 2 | Project Y | Zillenial Outreach | 3 | | 3 | Secret Project | Nowhere | 4 | | 4 | Waste of Time | HR HQ | 2 | +---------+----------------+--------------------+---------+ B4 rows in set (0.000 sec) BB BMariaDB [companys23]> select SSN,oPnumbercfrom Employee JOINorder by rand(); +-------------+---------+ | SSN | Pnumber | +-------------+---------+ | 439-93-4732 | 4 | | 740-55-0204 | 2 | | 519-28-6669 | 3 | | 649-68-0970 | 3 | | 180-68-1912 | 3 | | 449-14-0909 | 3 | | 609-89-7019 | 1 | | 526-92-5991 | 1 | | 874-24-1805 | 3 | | 250-86-3243 | 2 | | 803-13-5063 | 4 | | 663-54-0337 | 1 | | 554-96-0793 | 2 | | 108-30-6419 | 3 | | 178-09-9074 | 2 | | 442-52-4791 | 1 | | 134-43-6596 | 3 | | 521-52-7799 | 2 | | 725-13-9144 | 4 | | 521-52-7799 | 1 | | 199-45-7914 | 1 | | 357-26-8858 | 2 | | 632-84-2428 | 4 | | 640-78-3450 | 1 | | 827-84-9853 | 3 | | 486-81-9989 | 3 | | 533-85-8477 | 1 | | 221-78-4352 | 3 | | 155-65-2686 | 1 | | 663-54-0337 | 3 | | 486-81-9989 | 1 | | 688-21-1512 | 4 | | 476-67-1971 | 2 | | 449-14-0909 | 1 | | 615-18-6818 | 3 | | 486-81-9989 | 2 | | 515-40-9765 | 3 | | 861-96-0479 | 3 | | 356-90-7571 | 3 | | 484-58-1616 | 2 | | 799-59-0118 | 4 | | 720-58-9192 | 2 | | 489-86-9980 | 1 | | 626-86-0981 | 4 | | 609-89-7019 | 3 | | 180-68-1912 | 4 | | 224-05-5365 | 2 | | 645-89-3504 | 4 | | 788-79-8433 | 3 | | 195-36-4688 | 1 | | 169-88-1613 | 1 | | 250-42-9823 | 1 | | 467-54-3176 | 3 | | 414-10-4271 | 1 | | 622-30-0735 | 4 | | 852-63-0193 | 1 | | 717-85-9172 | 2 | | 725-13-9144 | 3 | | 785-69-1449 | 2 | | 609-89-7019 | 4 | | 665-86-8548 | 3 | | 252-70-1281 | 4 | | 515-40-9765 | 2 | | 199-45-7914 | 4 | | 476-67-1971 | 1 | | 788-79-8433 | 2 | | 769-08-1237 | 1 | | 439-93-4732 | 2 | | 369-50-5680 | 1 | | 447-39-2466 | 4 | | 548-58-9075 | 4 | | 600-82-6063 | 2 | | 852-63-0193 | 2 | | 730-73-1824 | 2 | | 508-50-6186 | 3 | | 368-34-7197 | 4 | | 632-84-2428 | 1 | | 600-82-6063 | 4 | | 532-76-3517 | 3 | | 720-58-9192 | 3 | | 218-15-2428 | 2 | | 632-84-2428 | 3 | | 519-28-6669 | 1 | | 861-96-0479 | 2 | | 536-16-5537 | 1 | | 850-85-0292 | 4 | | 827-84-9853 | 1 | | 575-99-3134 | 4 | | 155-65-2686 | 4 | | 581-28-8564 | 2 | | 548-58-9075 | 3 | | 893-15-9265 | 3 | | 831-68-7820 | 3 | | 785-69-1449 | 1 | | 515-40-9765 | 1 | | 740-55-0204 | 1 | | 407-66-4296 | 3 | | 311-57-2543 | 2 | | 259-67-9909 | 1 | | 581-28-8564 | 3 | | 521-40-4757 | 1 | | 407-66-4296 | 1 | | 799-59-0118 | 2 | | 575-99-5872 | 4 | | 508-50-6186 | 2 | | 521-40-4757 | 4 | | 801-55-5158 | 1 | | 526-92-5991 | 3 | | 688-21-1512 | 3 | | 850-85-0292 | 2 | | 489-86-9980 | 2 | | 615-18-6818 | 1 | | 259-67-9909 | 3 | | 622-30-0735 | 1 | | 827-84-9853 | 2 | | 112-77-5572 | 1 | | 608-12-4879 | 1 | | 248-16-5831 | 4 | | 543-29-8929 | 1 | | 575-99-5872 | 3 | | 310-24-7033 | 3 | | 658-02-8079 | 1 | | 368-34-7197 | 3 | | 463-13-5723 | 1 | | 279-97-0698 | 3 | | 665-86-8548 | 4 | | 195-36-4688 | 2 | | 375-34-0891 | 3 | | 195-36-4688 | 3 | | 521-52-7799 | 3 | | 600-82-6063 | 3 | | 575-99-3134 | 3 | | 157-88-7908 | 2 | | 250-86-3243 | 3 | | 533-85-8477 | 2 | | 852-63-0193 | 4 | | 861-96-0479 | 4 | | 206-42-6778 | 2 | | 484-58-1616 | 1 | | 640-78-3450 | 4 | | 221-78-4352 | 1 | | 740-55-0204 | 4 | | 676-04-3191 | 2 | | 310-24-7033 | 2 | | 356-90-7571 | 2 | | 442-52-4791 | 3 | | 218-15-2428 | 3 | | 356-90-7571 | 1 | | 508-50-6186 | 4 | | 596-37-9209 | 4 | | 785-69-1449 | 4 | | 730-73-1824 | 4 | | 134-43-6596 | 2 | | 157-88-7908 | 4 | | 626-86-0981 | 2 | | 554-96-0793 | 3 | | 829-82-9898 | 3 | | 368-34-7197 | 1 | | 676-04-3191 | 1 | | 447-39-2466 | 1 | | 649-68-0970 | 1 | | 769-08-1237 | 4 | | 157-88-7908 | 3 | | 178-09-9074 | 1 | | 357-26-8858 | 1 | | 575-99-3134 | 1 | | 259-69-3521 | 4 | | 829-82-9898 | 1 | | 720-58-9192 | 4 | | 169-88-1613 | 4 | | 252-70-1281 | 1 | | 649-68-0970 | 2 | | 855-68-5051 | 2 | | 831-68-7820 | 2 | | 250-45-6366 | 3 | | 536-16-5537 | 4 | | 178-09-9074 | 4 | | 486-81-9989 | 4 | | 250-45-6366 | 2 | | 532-76-3517 | 1 | | 735-36-0902 | 4 | | 310-24-7033 | 4 | | 658-02-8079 | 3 | | 252-70-1281 | 2 | | 893-15-9265 | 4 | | 206-42-6778 | 1 | | 407-66-4296 | 4 | | 248-16-5831 | 2 | | 221-78-4352 | 4 | | 615-18-6818 | 4 | | 112-77-5572 | 4 | | 893-15-9265 | 1 | | 862-55-5133 | 3 | | 640-78-3450 | 2 | | 221-78-4352 | 2 | | 489-86-9980 | 4 | | 224-05-5365 | 3 | | 663-54-0337 | 4 | | 327-45-5907 | 1 | | 855-68-5051 | 4 | | 663-54-0337 | 2 | | 801-55-5158 | 4 | | 581-28-8564 | 1 | | 521-40-4757 | 2 | | 463-13-5723 | 3 | | 442-52-4791 | 4 | | 169-88-1613 | 3 | | 279-97-0698 | 4 | | 259-69-3521 | 3 | | 311-57-2543 | 4 | | 311-57-2543 | 3 | | 688-21-1512 | 1 | | 640-78-3450 | 3 | | 730-73-1824 | 1 | | 769-08-1237 | 2 | | 515-40-9765 | 4 | | 788-79-8433 | 4 | | 449-14-0909 | 2 | | 519-28-6669 | 2 | | 676-04-3191 | 3 | | 554-96-0793 | 4 | | 769-08-1237 | 3 | | 442-52-4791 | 2 | | 735-36-0902 | 1 | | 862-55-5133 | 1 | | 532-76-3517 | 2 | | 532-76-3517 | 4 | | 735-36-0902 | 2 | | 575-99-5872 | 2 | | 735-36-0902 | 3 | | 526-92-5991 | 2 | | 600-82-6063 | 1 | | 665-86-8548 | 2 | | 484-58-1616 | 4 | | 596-37-9209 | 3 | | 134-43-6596 | 4 | | 803-13-5063 | 3 | | 484-58-1616 | 3 | | 250-42-9823 | 4 | | 862-55-5133 | 2 | | 521-52-7799 | 4 | | 665-86-8548 | 1 | | 536-16-5537 | 2 | | 519-28-6669 | 4 | | 248-16-5831 | 1 | | 626-86-0981 | 3 | | 717-85-9172 | 3 | | 785-69-1449 | 3 | | 855-68-5051 | 3 | | 301-24-1567 | 3 | | 199-45-7914 | 2 | | 248-16-5831 | 3 | | 414-10-4271 | 2 | | 874-24-1805 | 1 | | 259-67-9909 | 2 | | 357-26-8858 | 3 | | 440-89-5164 | 4 | | 447-39-2466 | 2 | | 476-67-1971 | 3 | | 327-45-5907 | 4 | | 632-84-2428 | 2 | | 831-68-7820 | 4 | | 829-82-9898 | 2 | | 259-67-9909 | 4 | | 310-24-7033 | 1 | | 720-58-9192 | 1 | | 224-05-5365 | 4 | | 112-77-5572 | 2 | | 717-85-9172 | 4 | | 688-21-1512 | 2 | | 851-37-9880 | 4 | | 108-30-6419 | 2 | | 850-85-0292 | 3 | | 755-49-5779 | 3 | | 543-29-8929 | 2 | | 676-04-3191 | 4 | | 609-89-7019 | 2 | | 626-86-0981 | 1 | | 615-18-6818 | 2 | | 851-37-9880 | 3 | | 855-68-5051 | 1 | | 259-69-3521 | 1 | | 608-12-4879 | 4 | | 645-74-0526 | 2 | | 755-49-5779 | 4 | | 649-68-0970 | 4 | | 803-13-5063 | 2 | | 206-42-6778 | 3 | | 250-42-9823 | 2 | | 195-36-4688 | 4 | | 799-59-0118 | 1 | | 407-66-4296 | 2 | | 467-54-3176 | 4 | | 218-15-2428 | 1 | | 801-55-5158 | 3 | | 851-37-9880 | 2 | | 658-02-8079 | 4 | | 874-24-1805 | 4 | | 169-88-1613 | 2 | | 440-89-5164 | 2 | | 224-05-5365 | 1 | | 368-34-7197 | 2 | | 645-89-3504 | 3 | | 717-85-9172 | 1 | | 827-84-9853 | 4 | | 327-45-5907 | 2 | | 199-45-7914 | 3 | | 250-45-6366 | 1 | | 279-97-0698 | 2 | | 575-99-3134 | 2 | | 803-13-5063 | 1 | | 725-13-9144 | 1 | | 178-09-9074 | 3 | | 861-96-0479 | 1 | | 608-12-4879 | 2 | | 489-86-9980 | 3 | | 414-10-4271 | 4 | | 447-39-2466 | 3 | | 543-29-8929 | 3 | | 250-42-9823 | 3 | | 108-30-6419 | 1 | | 375-34-0891 | 2 | | 608-12-4879 | 3 | | 645-89-3504 | 2 | | 108-30-6419 | 4 | | 730-73-1824 | 3 | | 311-57-2543 | 1 | | 155-65-2686 | 3 | | 536-16-5537 | 3 | | 301-24-1567 | 1 | | 508-50-6186 | 1 | | 440-89-5164 | 3 | | 414-10-4271 | 3 | | 301-24-1567 | 2 | | 440-89-5164 | 1 | | 725-13-9144 | 2 | | 622-30-0735 | 2 | | 874-24-1805 | 2 | | 357-26-8858 | 4 | | 180-68-1912 | 2 | | 801-55-5158 | 2 | | 439-93-4732 | 3 | | 467-54-3176 | 2 | | 250-86-3243 | 1 | | 301-24-1567 | 4 | | 157-88-7908 | 1 | | 356-90-7571 | 4 | | 463-13-5723 | 2 | | 862-55-5133 | 4 | | 575-99-5872 | 1 | | 369-50-5680 | 4 | | 533-85-8477 | 3 | | 755-49-5779 | 1 | | 645-74-0526 | 4 | | 218-15-2428 | 4 | | 155-65-2686 | 2 | | 533-85-8477 | 4 | | 788-79-8433 | 1 | | 622-30-0735 | 3 | | 180-68-1912 | 1 | | 134-43-6596 | 1 | | 543-29-8929 | 4 | | 851-37-9880 | 1 | | 476-67-1971 | 4 | | 521-40-4757 | 3 | | 645-74-0526 | 1 | | 327-45-5907 | 3 | | 369-50-5680 | 2 | | 250-86-3243 | 4 | | 645-89-3504 | 1 | | 526-92-5991 | 4 | | 375-34-0891 | 4 | | 850-85-0292 | 1 | | 439-93-4732 | 1 | | 893-15-9265 | 2 | | 369-50-5680 | 3 | | 596-37-9209 | 2 | | 375-34-0891 | 1 | | 548-58-9075 | 2 | | 658-02-8079 | 2 | | 467-54-3176 | 1 | | 463-13-5723 | 4 | | 206-42-6778 | 4 | | 252-70-1281 | 3 | | 581-28-8564 | 4 | | 596-37-9209 | 1 | | 449-14-0909 | 4 | | 250-45-6366 | 4 | | 645-74-0526 | 3 | | 259-69-3521 | 2 | | 852-63-0193 | 3 | | 112-77-5572 | 3 | | 554-96-0793 | 1 | | 831-68-7820 | 1 | | 799-59-0118 | 3 | | 740-55-0204 | 3 | | 279-97-0698 | 1 | | 755-49-5779 | 2 | | 548-58-9075 | 1 | | 829-82-9898 | 4 | +-------------+---------+ B400 rows in set (0.001 sec) BB BMariaDB [companys23]> select SSN, Pnumber,rand()*50asHoursIN Project order by rand(); +-------------+---------+---------------------+ | SSN | Pnumber | Hours | +-------------+---------+---------------------+ | 108-30-6419 | 4 | 3.800713181310066 | | 609-89-7019 | 3 | 20.281407349073707 | | 658-02-8079 | 1 | 36.067600488725674 | | 532-76-3517 | 3 | 47.30224208655044 | | 356-90-7571 | 3 | 16.882092987077396 | | 645-89-3504 | 1 | 11.668494308058634 | | 463-13-5723 | 1 | 23.9860241524745 | | 676-04-3191 | 1 | 43.37475969770435 | | 310-24-7033 | 4 | 7.970529383020969 | | 248-16-5831 | 2 | 30.141163692009787 | | 439-93-4732 | 2 | 7.429168659662054 | | 486-81-9989 | 3 | 25.825034664780866 | | 375-34-0891 | 3 | 8.657516454027515 | | 720-58-9192 | 2 | 35.23712110262096 | | 725-13-9144 | 1 | 0.3402587029526557 | | 250-86-3243 | 3 | 3.834518654117844 | | 717-85-9172 | 1 | 10.582950674540317 | | 368-34-7197 | 2 | 30.152112553037806 | | 259-67-9909 | 1 | 19.01469558385638 | | 688-21-1512 | 1 | 45.68762895249541 | | 717-85-9172 | 2 | 34.42436986083572 | | 218-15-2428 | 3 | 47.9280450362042 | | 259-67-9909 | 3 | 29.79701490122547 | | 414-10-4271 | 1 | 0.8092337295499014 | | 375-34-0891 | 4 | 12.616391584851213 | | 180-68-1912 | 4 | 15.150064057810292 | | 554-96-0793 | 1 | 14.461845685226699 | | 206-42-6778 | 2 | 12.913455453620717 | | 439-93-4732 | 1 | 43.918237689806375 | | 850-85-0292 | 4 | 4.030029060347032 | | 663-54-0337 | 2 | 37.59911250099457 | | 375-34-0891 | 2 | 32.747632994081485 | | 301-24-1567 | 2 | 36.04391825948275 | | 827-84-9853 | 1 | 7.791897196128869 | | 676-04-3191 | 3 | 21.815612885929283 | | 108-30-6419 | 3 | 25.799759454838707 | | 788-79-8433 | 2 | 20.961168381349342 | | 206-42-6778 | 3 | 34.03453760224817 | | 250-86-3243 | 1 | 1.0878540585635734 | | 221-78-4352 | 3 | 36.49821489723233 | | 799-59-0118 | 1 | 11.302687517649202 | | 206-42-6778 | 1 | 8.62815422809511 | | 788-79-8433 | 4 | 33.78020216131601 | | 554-96-0793 | 2 | 20.231671231083265 | | 862-55-5133 | 3 | 2.2353349274353453 | | 369-50-5680 | 1 | 16.70531403897825 | | 861-96-0479 | 3 | 0.9610526272664337 | | 801-55-5158 | 3 | 4.405234478791463 | | 720-58-9192 | 4 | 23.93078489595166 | | 134-43-6596 | 4 | 2.2946188713373794 | | 645-89-3504 | 4 | 46.09327115685984 | | 178-09-9074 | 3 | 27.04355593495402 | | 467-54-3176 | 4 | 3.394013180764404 | | 850-85-0292 | 1 | 4.583927853576772 | | 259-69-3521 | 1 | 30.435129190269045 | | 195-36-4688 | 4 | 7.907719591546543 | | 785-69-1449 | 1 | 49.08477659251986 | | 155-65-2686 | 1 | 1.1836139496263247 | | 851-37-9880 | 3 | 48.30347089870225 | | 831-68-7820 | 4 | 8.734943027361243 | | 442-52-4791 | 1 | 32.741784521138094 | | 521-52-7799 | 4 | 23.921106731445626 | | 658-02-8079 | 2 | 19.67246334037973 | | 730-73-1824 | 3 | 29.422655216811833 | | 532-76-3517 | 1 | 28.34680567341559 | | 532-76-3517 | 2 | 35.07054963621362 | | 112-77-5572 | 4 | 7.981028974038576 | | 874-24-1805 | 3 | 10.324537018616253 | | 861-96-0479 | 2 | 26.225088235200467 | | 484-58-1616 | 2 | 21.761407537163617 | | 218-15-2428 | 1 | 48.94675221196073 | | 827-84-9853 | 3 | 24.01634317265483 | | 489-86-9980 | 1 | 44.76477261145113 | | 224-05-5365 | 4 | 44.90736596743331 | | 369-50-5680 | 3 | 40.972409854617354 | | 199-45-7914 | 4 | 41.46012639762846 | | 521-52-7799 | 1 | 36.80755867325474 | | 801-55-5158 | 1 | 3.931651081826213 | | 548-58-9075 | 1 | 21.16424345519789 | | 407-66-4296 | 4 | 38.213130075683004 | | 850-85-0292 | 2 | 35.315215294542924 | | 439-93-4732 | 4 | 15.931226001988374 | | 134-43-6596 | 3 | 27.43850115448097 | | 112-77-5572 | 3 | 47.80241832863765 | | 581-28-8564 | 1 | 39.826786834585285 | | 536-16-5537 | 4 | 3.3255032760328644 | | 357-26-8858 | 2 | 12.69996251231056 | | 803-13-5063 | 4 | 4.277994254862884 | | 596-37-9209 | 1 | 0.738564646559362 | | 799-59-0118 | 2 | 22.615410315446006 | | 521-40-4757 | 3 | 8.538065113628344 | | 178-09-9074 | 2 | 18.153110535957953 | | 407-66-4296 | 3 | 7.612811548274766 | | 543-29-8929 | 2 | 34.59387373607035 | | 645-89-3504 | 2 | 20.75571703794945 | | 259-69-3521 | 2 | 43.259821593072104 | | 476-67-1971 | 4 | 24.852686538223818 | | 554-96-0793 | 4 | 18.44148781936754 | | 178-09-9074 | 4 | 29.762839786487483 | | 155-65-2686 | 3 | 38.44559713122025 | | 442-52-4791 | 2 | 6.885318511058873 | | 508-50-6186 | 1 | 4.989484143433612 | | 640-78-3450 | 2 | 10.512529695883886 | | 827-84-9853 | 2 | 39.45299376682657 | | 407-66-4296 | 2 | 0.08057728417271495 | | 663-54-0337 | 1 | 41.18411158321808 | | 357-26-8858 | 4 | 30.13848986489558 | | 327-45-5907 | 4 | 33.9095034952364 | | 626-86-0981 | 4 | 26.643895056698376 | | 640-78-3450 | 3 | 38.456860732712656 | | 169-88-1613 | 2 | 45.36973982618166 | | 248-16-5831 | 1 | 45.76303800173387 | | 676-04-3191 | 4 | 41.58778194485957 | | 717-85-9172 | 3 | 18.955767032649153 | | 327-45-5907 | 1 | 11.495797765902987 | | 533-85-8477 | 3 | 20.85835972880792 | | 521-40-4757 | 4 | 26.58368742706598 | | 519-28-6669 | 2 | 37.21388861277502 | | 622-30-0735 | 3 | 5.812310851935587 | | 447-39-2466 | 1 | 4.971683495651636 | | 851-37-9880 | 4 | 4.639747556894783 | | 676-04-3191 | 2 | 49.7950335031329 | | 112-77-5572 | 2 | 1.033245540254978 | | 484-58-1616 | 1 | 17.39720619972535 | | 311-57-2543 | 3 | 0.398965552820792 | | 874-24-1805 | 4 | 15.426782113897412 | | 252-70-1281 | 1 | 8.697560158276522 | | 476-67-1971 | 1 | 11.5909717619335 | | 521-40-4757 | 1 | 32.157427987230406 | | 199-45-7914 | 1 | 1.2451551400545566 | | 180-68-1912 | 2 | 33.8049949927302 | | 112-77-5572 | 1 | 11.178479866290912 | | 622-30-0735 | 2 | 22.56806597352779 | | 252-70-1281 | 2 | 45.058940951767326 | | 735-36-0902 | 3 | 37.34154499819646 | | 180-68-1912 | 1 | 0.44958177064506505 | | 157-88-7908 | 1 | 46.96521120794603 | | 663-54-0337 | 4 | 10.960847522095635 | | 526-92-5991 | 2 | 27.62819996814076 | | 508-50-6186 | 3 | 39.21574693100131 | | 195-36-4688 | 1 | 41.56845034246189 | | 369-50-5680 | 4 | 36.92494555090084 | | 463-13-5723 | 4 | 15.16411338482435 | | 532-76-3517 | 4 | 2.1153572035165107 | | 440-89-5164 | 3 | 30.62312605848827 | | 169-88-1613 | 1 | 0.21817502586001067 | | 801-55-5158 | 2 | 41.767507970116576 | | 301-24-1567 | 3 | 30.174659872590247 | | 581-28-8564 | 4 | 18.983726127989335 | | 740-55-0204 | 2 | 5.579224373753392 | | 575-99-3134 | 4 | 27.489095998452136 | | 645-89-3504 | 3 | 29.519197139441218 | | 224-05-5365 | 1 | 32.81006769538863 | | 279-97-0698 | 4 | 39.561352077463035 | | 533-85-8477 | 2 | 34.053562426989494 | | 327-45-5907 | 3 | 20.364088956605723 | | 108-30-6419 | 2 | 32.105587592446795 | | 852-63-0193 | 4 | 38.25903901668176 | | 515-40-9765 | 2 | 25.804713578712864 | | 521-52-7799 | 3 | 26.137312945106355 | | 218-15-2428 | 4 | 49.766540899655354 | | 615-18-6818 | 4 | 16.335315039693672 | | 626-86-0981 | 3 | 10.18292099254478 | | 178-09-9074 | 1 | 44.148984359716046 | | 548-58-9075 | 3 | 28.789462362220007 | | 829-82-9898 | 2 | 27.429347697113965 | | 195-36-4688 | 2 | 26.13063298736758 | | 632-84-2428 | 3 | 24.61525404324313 | | 608-12-4879 | 2 | 19.203301816436742 | | 155-65-2686 | 2 | 24.64868945502554 | | 356-90-7571 | 1 | 0.7147747098605844 | | 893-15-9265 | 2 | 26.775995527185497 | | 596-37-9209 | 4 | 0.41428264269072806 | | 195-36-4688 | 3 | 25.312564266205364 | | 536-16-5537 | 3 | 9.16641574275346 | | 221-78-4352 | 1 | 11.947504814665304 | | 180-68-1912 | 3 | 5.9443421717214795 | | 855-68-5051 | 4 | 32.13115616900023 | | 688-21-1512 | 4 | 21.043039458843914 | | 519-28-6669 | 1 | 30.644527990971255 | | 720-58-9192 | 3 | 4.128250716373557 | | 688-21-1512 | 3 | 44.565615239148606 | | 829-82-9898 | 4 | 7.291139249961022 | | 515-40-9765 | 3 | 34.03706600334222 | | 861-96-0479 | 4 | 5.257293074631405 | | 893-15-9265 | 3 | 33.018703742901515 | | 301-24-1567 | 1 | 20.54495156793385 | | 862-55-5133 | 2 | 24.6866163096266 | | 851-37-9880 | 1 | 6.636771612462375 | | 575-99-3134 | 3 | 11.637979989534225 | | 575-99-3134 | 1 | 37.51183677232996 | | 831-68-7820 | 2 | 40.851243157732526 | | 665-86-8548 | 2 | 30.086079500695767 | | 463-13-5723 | 2 | 22.243950769532425 | | 250-45-6366 | 4 | 22.97406943791925 | | 615-18-6818 | 2 | 19.36005723603075 | | 476-67-1971 | 3 | 16.089766766959585 | | 740-55-0204 | 3 | 4.22678208372256 | | 649-68-0970 | 3 | 3.75470826751991 | | 803-13-5063 | 1 | 16.78442453666071 | | 735-36-0902 | 1 | 33.558126151150205 | | 221-78-4352 | 2 | 45.62844768690732 | | 600-82-6063 | 1 | 41.90497998325618 | | 862-55-5133 | 4 | 29.645598753956705 | | 489-86-9980 | 3 | 9.647135911180763 | | 356-90-7571 | 2 | 45.39390946309446 | | 663-54-0337 | 3 | 15.73552365017638 | | 785-69-1449 | 4 | 31.520231935680126 | | 615-18-6818 | 3 | 20.82326595748148 | | 526-92-5991 | 1 | 1.8287183268263174 | | 658-02-8079 | 3 | 21.22272860372693 | | 827-84-9853 | 4 | 8.398950247465587 | | 893-15-9265 | 1 | 1.8246350826924995 | | 622-30-0735 | 4 | 19.220106275025852 | | 622-30-0735 | 1 | 21.40155189801152 | | 311-57-2543 | 4 | 15.658547604138542 | | 575-99-5872 | 2 | 3.802592823098035 | | 252-70-1281 | 3 | 0.3286962866119075 | | 449-14-0909 | 3 | 19.310265797479325 | | 250-45-6366 | 3 | 30.969469650620102 | | 829-82-9898 | 3 | 5.537366825656376 | | 548-58-9075 | 4 | 25.278053456245043 | | 449-14-0909 | 2 | 22.166428642502453 | | 730-73-1824 | 1 | 26.17968723753438 | | 375-34-0891 | 1 | 17.44042454980353 | | 449-14-0909 | 4 | 22.427988026689725 | | 632-84-2428 | 4 | 15.210761609683523 | | 449-14-0909 | 1 | 22.66281752163807 | | 851-37-9880 | 2 | 28.42427289897974 | | 327-45-5907 | 2 | 40.818400346504895 | | 206-42-6778 | 4 | 17.924569982965078 | | 279-97-0698 | 1 | 0.9973944639762813 | | 311-57-2543 | 1 | 22.873743086004392 | | 855-68-5051 | 1 | 41.821090962571176 | | 259-67-9909 | 2 | 28.142992153896945 | | 649-68-0970 | 2 | 22.50132632674773 | | 893-15-9265 | 4 | 41.74724723375146 | | 658-02-8079 | 4 | 39.17267652151424 | | 740-55-0204 | 4 | 11.308721649748014 | | 665-86-8548 | 4 | 12.489569198796124 | | 799-59-0118 | 3 | 31.321427860596618 | | 665-86-8548 | 3 | 9.229401554194654 | | 735-36-0902 | 2 | 31.18663973285504 | | 755-49-5779 | 3 | 34.76796837967631 | | 725-13-9144 | 3 | 15.601152522117973 | | 199-45-7914 | 2 | 26.536019124589878 | | 447-39-2466 | 4 | 36.76123231347765 | | 785-69-1449 | 2 | 7.121431275383971 | | 467-54-3176 | 1 | 9.580104155074903 | | 250-42-9823 | 4 | 8.230035620024461 | | 259-69-3521 | 3 | 24.32695387334279 | | 414-10-4271 | 2 | 35.24645351362084 | | 600-82-6063 | 2 | 15.398516659996023 | | 874-24-1805 | 2 | 10.482398011239615 | | 486-81-9989 | 4 | 47.60082643255668 | | 526-92-5991 | 4 | 2.3203500568124933 | | 357-26-8858 | 3 | 20.052892779980684 | | 645-74-0526 | 4 | 36.7944150108792 | | 250-42-9823 | 1 | 15.241180374511687 | | 533-85-8477 | 4 | 2.9065933571258498 | | 157-88-7908 | 2 | 46.66005796441814 | | 855-68-5051 | 3 | 8.76069349121367 | | 369-50-5680 | 2 | 1.2261529464518215 | | 357-26-8858 | 1 | 12.214595416760627 | | 259-69-3521 | 4 | 21.95663002501859 | | 543-29-8929 | 1 | 37.22173491234121 | | 414-10-4271 | 3 | 10.063373260259043 | | 600-82-6063 | 3 | 19.788151206251374 | | 575-99-3134 | 2 | 34.68630684976122 | | 484-58-1616 | 3 | 2.6759020077771525 | | 862-55-5133 | 1 | 15.397752649521223 | | 439-93-4732 | 3 | 47.773184345823886 | | 831-68-7820 | 3 | 47.559146580807074 | | 169-88-1613 | 3 | 34.3408752086953 | | 600-82-6063 | 4 | 46.97596435153481 | | 489-86-9980 | 2 | 5.850118683511502 | | 596-37-9209 | 3 | 19.533212268290306 | | 301-24-1567 | 4 | 11.628866765302481 | | 575-99-5872 | 1 | 18.054132832264653 | | 852-63-0193 | 2 | 9.668959872488827 | | 645-74-0526 | 1 | 7.321326255166276 | | 536-16-5537 | 1 | 33.10766674867614 | | 608-12-4879 | 1 | 38.756253094185375 | | 536-16-5537 | 2 | 15.215575336679422 | | 803-13-5063 | 3 | 35.717658545558955 | | 608-12-4879 | 3 | 19.489796105297092 | | 861-96-0479 | 1 | 35.96261044588183 | | 581-28-8564 | 3 | 21.891324940967678 | | 157-88-7908 | 4 | 37.86036552662064 | | 248-16-5831 | 4 | 41.68465746723549 | | 155-65-2686 | 4 | 25.5421684827117 | | 554-96-0793 | 3 | 18.42837684641441 | | 575-99-5872 | 4 | 27.17314602543893 | | 279-97-0698 | 3 | 5.041754529850328 | | 640-78-3450 | 4 | 34.586801924357935 | | 440-89-5164 | 1 | 40.82799846383556 | | 769-08-1237 | 3 | 13.989321341728159 | | 310-24-7033 | 2 | 11.13048844144725 | | 108-30-6419 | 1 | 32.234219631398304 | | 508-50-6186 | 4 | 20.7170944853845 | | 157-88-7908 | 3 | 45.7978254144991 | | 725-13-9144 | 2 | 28.335177459134886 | | 543-29-8929 | 4 | 24.71523547984216 | | 526-92-5991 | 3 | 4.05266271350222 | | 519-28-6669 | 4 | 45.42182245796716 | | 769-08-1237 | 1 | 41.40531461816776 | | 533-85-8477 | 1 | 19.019080576504656 | | 543-29-8929 | 3 | 34.84649549689749 | | 575-99-5872 | 3 | 27.69096324005254 | | 740-55-0204 | 1 | 28.80961120017768 | | 476-67-1971 | 2 | 17.882312198991247 | | 803-13-5063 | 2 | 30.222083842588667 | | 608-12-4879 | 4 | 27.263661359682363 | | 645-74-0526 | 2 | 33.20196274034862 | | 632-84-2428 | 1 | 8.944871983439542 | | 609-89-7019 | 4 | 32.283152343969 | | 521-40-4757 | 2 | 15.6732230593201 | | 486-81-9989 | 1 | 19.76412950992969 | | 259-67-9909 | 4 | 39.435538872550744 | | 447-39-2466 | 3 | 39.7961731905082 | | 688-21-1512 | 2 | 38.62910297571598 | | 368-34-7197 | 1 | 12.85636756835167 | | 596-37-9209 | 2 | 1.2243022222298219 | | 463-13-5723 | 3 | 36.158057987837175 | | 632-84-2428 | 2 | 8.500636563171295 | | 218-15-2428 | 2 | 5.043521015945376 | | 730-73-1824 | 2 | 36.16359297760165 | | 626-86-0981 | 1 | 47.476423482854315 | | 788-79-8433 | 3 | 44.240393623933564 | | 250-86-3243 | 4 | 4.090503653595693 | | 626-86-0981 | 2 | 28.94620856172052 | | 484-58-1616 | 4 | 6.754539447607975 | | 581-28-8564 | 2 | 2.249728750670076 | | 519-28-6669 | 3 | 48.26749535116134 | | 801-55-5158 | 4 | 48.797492309284856 | | 199-45-7914 | 3 | 31.043239618691835 | | 508-50-6186 | 2 | 48.71945176154324 | | 279-97-0698 | 2 | 42.68915312615144 | | 799-59-0118 | 4 | 27.596820218113084 | | 649-68-0970 | 1 | 24.063306137978387 | | 356-90-7571 | 4 | 10.622466737984183 | | 755-49-5779 | 4 | 14.145283414186244 | | 640-78-3450 | 1 | 32.95963563300635 | | 649-68-0970 | 4 | 41.53005619675857 | | 447-39-2466 | 2 | 3.718276325350885 | | 755-49-5779 | 2 | 21.688184488274327 | | 368-34-7197 | 4 | 26.097863517792767 | | 134-43-6596 | 2 | 7.794213535072481 | | 548-58-9075 | 2 | 39.80483840201501 | | 442-52-4791 | 4 | 18.50322975637692 | | 440-89-5164 | 4 | 45.77332553060104 | | 852-63-0193 | 3 | 39.37890025729211 | | 615-18-6818 | 1 | 10.112326927587695 | | 486-81-9989 | 2 | 26.53855045935004 | | 769-08-1237 | 4 | 46.29061887626594 | | 224-05-5365 | 3 | 46.871521227873416 | | 250-45-6366 | 2 | 1.9861095137764788 | | 785-69-1449 | 3 | 1.625120641314537 | | 310-24-7033 | 3 | 39.7445297704493 | | 829-82-9898 | 1 | 1.2335902091428546 | | 735-36-0902 | 4 | 22.80051375068772 | | 609-89-7019 | 2 | 26.885777084981815 | | 250-45-6366 | 1 | 31.613469292981055 | | 515-40-9765 | 1 | 6.624139665275942 | | 831-68-7820 | 1 | 8.345854243585704 | | 414-10-4271 | 4 | 23.291028592075246 | | 874-24-1805 | 1 | 20.291830664772384 | | 221-78-4352 | 4 | 42.27136722046078 | | 368-34-7197 | 3 | 38.009380677723684 | | 720-58-9192 | 1 | 18.82753397228898 | | 250-86-3243 | 2 | 17.928896721386252 | | 855-68-5051 | 2 | 34.10216237800397 | | 407-66-4296 | 1 | 19.552100887104963 | | 755-49-5779 | 1 | 16.341357134600504 | | 852-63-0193 | 1 | 1.9169772527338726 | | 442-52-4791 | 3 | 14.291997732866554 | | 730-73-1824 | 4 | 6.409513909751096 | | 134-43-6596 | 1 | 9.53372876116422 | | 725-13-9144 | 4 | 35.86302589239834 | | 252-70-1281 | 4 | 11.75457729190083 | | 248-16-5831 | 3 | 47.52020677320679 | | 467-54-3176 | 2 | 28.26532686898981 | | 311-57-2543 | 2 | 41.64873053473302 | | 310-24-7033 | 1 | 48.923287074010155 | | 440-89-5164 | 2 | 2.241212737039861 | | 489-86-9980 | 4 | 5.722792545075335 | | 850-85-0292 | 3 | 34.718842883332485 | | 717-85-9172 | 4 | 9.45636379481886 | | 467-54-3176 | 3 | 6.495105714066984 | | 169-88-1613 | 4 | 41.9649105909885 | | 224-05-5365 | 2 | 7.949357952875419 | | 788-79-8433 | 1 | 30.095854057088356 | | 515-40-9765 | 4 | 22.916945091371375 | | 250-42-9823 | 2 | 19.200067239999836 | | 665-86-8548 | 1 | 45.24619434517454 | | 521-52-7799 | 2 | 23.233013668314566 | | 769-08-1237 | 2 | 6.87394091568323 | | 609-89-7019 | 1 | 37.388236808952165 | | 250-42-9823 | 3 | 40.73097080991694 | | 645-74-0526 | 3 | 49.68757079885115 | +-------------+---------+---------------------+ B400 rows in set (0.002 sec) BB BMariaDB [companys23]> select SSN, Pnumber, ound)) * 50 as Hours from Employee JOIN Project order by rand(); +-------------+---------+-------+ | SSN | Pnumber | Hours | +-------------+---------+-------+ | 735-36-0902 | 1 | 16 | | 463-13-5723 | 2 | 14 | | 449-14-0909 | 1 | 44 | | 717-85-9172 | 3 | 9 | | 279-97-0698 | 3 | 32 | | 533-85-8477 | 1 | 41 | | 831-68-7820 | 1 | 9 | | 827-84-9853 | 1 | 28 | | 615-18-6818 | 1 | 47 | | 855-68-5051 | 4 | 10 | | 720-58-9192 | 2 | 14 | | 645-89-3504 | 4 | 29 | | 310-24-7033 | 2 | 40 | | 665-86-8548 | 4 | 9 | | 688-21-1512 | 2 | 26 | | 730-73-1824 | 1 | 10 | | 725-13-9144 | 4 | 4 | | 447-39-2466 | 4 | 14 | | 508-50-6186 | 4 | 11 | | 862-55-5133 | 3 | 25 | | 548-58-9075 | 4 | 23 | | 199-45-7914 | 4 | 20 | | 134-43-6596 | 3 | 15 | | 526-92-5991 | 1 | 40 | | 250-45-6366 | 4 | 34 | | 180-68-1912 | 4 | 30 | | 581-28-8564 | 4 | 37 | | 862-55-5133 | 2 | 12 | | 769-08-1237 | 4 | 48 | | 852-63-0193 | 4 | 32 | | 134-43-6596 | 1 | 31 | | 600-82-6063 | 2 | 36 | | 476-67-1971 | 2 | 7 | | 533-85-8477 | 4 | 47 | | 769-08-1237 | 1 | 23 | | 311-57-2543 | 1 | 35 | | 649-68-0970 | 2 | 5 | | 554-96-0793 | 2 | 16 | | 575-99-3134 | 2 | 21 | | 327-45-5907 | 2 | 35 | | 827-84-9853 | 3 | 12 | | 548-58-9075 | 2 | 9 | | 532-76-3517 | 2 | 38 | | 543-29-8929 | 2 | 11 | | 640-78-3450 | 3 | 12 | | 663-54-0337 | 1 | 30 | | 206-42-6778 | 2 | 47 | | 609-89-7019 | 2 | 14 | | 476-67-1971 | 1 | 37 | | 519-28-6669 | 1 | 17 | | 688-21-1512 | 1 | 40 | | 486-81-9989 | 3 | 25 | | 596-37-9209 | 1 | 7 | | 259-67-9909 | 1 | 9 | | 533-85-8477 | 3 | 44 | | 626-86-0981 | 2 | 8 | | 852-63-0193 | 3 | 33 | | 730-73-1824 | 2 | 9 | | 893-15-9265 | 1 | 41 | | 375-34-0891 | 1 | 15 | | 735-36-0902 | 2 | 42 | | 248-16-5831 | 3 | 1 | | 463-13-5723 | 1 | 48 | | 508-50-6186 | 3 | 9 | | 250-42-9823 | 3 | 28 | | 447-39-2466 | 1 | 16 | | 521-52-7799 | 1 | 0 | | 311-57-2543 | 2 | 1 | | 801-55-5158 | 2 | 13 | | 199-45-7914 | 3 | 21 | | 250-86-3243 | 4 | 24 | | 112-77-5572 | 2 | 3 | | 851-37-9880 | 1 | 34 | | 250-42-9823 | 4 | 26 | | 861-96-0479 | 2 | 11 | | 575-99-3134 | 1 | 4 | | 676-04-3191 | 3 | 0 | | 575-99-5872 | 2 | 24 | | 803-13-5063 | 1 | 2 | | 649-68-0970 | 3 | 36 | | 178-09-9074 | 1 | 24 | | 169-88-1613 | 4 | 5 | | 250-45-6366 | 2 | 50 | | 327-45-5907 | 3 | 46 | | 311-57-2543 | 4 | 48 | | 615-18-6818 | 3 | 33 | | 484-58-1616 | 2 | 32 | | 861-96-0479 | 1 | 16 | | 626-86-0981 | 1 | 0 | | 658-02-8079 | 3 | 17 | | 467-54-3176 | 1 | 36 | | 248-16-5831 | 1 | 30 | | 259-69-3521 | 1 | 33 | | 640-78-3450 | 4 | 41 | | 248-16-5831 | 4 | 24 | | 519-28-6669 | 2 | 15 | | 640-78-3450 | 1 | 40 | | 178-09-9074 | 2 | 0 | | 195-36-4688 | 3 | 10 | | 725-13-9144 | 2 | 3 | | 852-63-0193 | 1 | 28 | | 850-85-0292 | 1 | 33 | | 221-78-4352 | 1 | 45 | | 609-89-7019 | 4 | 39 | | 526-92-5991 | 3 | 14 | | 155-65-2686 | 4 | 23 | | 178-09-9074 | 3 | 18 | | 224-05-5365 | 4 | 42 | | 463-13-5723 | 4 | 29 | | 851-37-9880 | 2 | 48 | | 486-81-9989 | 1 | 23 | | 893-15-9265 | 2 | 29 | | 442-52-4791 | 3 | 41 | | 310-24-7033 | 4 | 39 | | 850-85-0292 | 2 | 25 | | 250-86-3243 | 1 | 41 | | 554-96-0793 | 3 | 28 | | 155-65-2686 | 1 | 32 | | 447-39-2466 | 2 | 33 | | 632-84-2428 | 2 | 42 | | 632-84-2428 | 3 | 1 | | 221-78-4352 | 3 | 7 | | 515-40-9765 | 4 | 36 | | 356-90-7571 | 4 | 17 | | 755-49-5779 | 2 | 8 | | 596-37-9209 | 4 | 8 | | 720-58-9192 | 3 | 39 | | 521-52-7799 | 3 | 32 | | 476-67-1971 | 4 | 21 | | 206-42-6778 | 3 | 43 | | 224-05-5365 | 2 | 8 | | 519-28-6669 | 4 | 33 | | 259-67-9909 | 2 | 25 | | 801-55-5158 | 1 | 29 | | 829-82-9898 | 4 | 49 | | 155-65-2686 | 3 | 44 | | 218-15-2428 | 4 | 30 | | 536-16-5537 | 3 | 46 | | 439-93-4732 | 3 | 50 | | 250-45-6366 | 3 | 40 | | 515-40-9765 | 1 | 14 | | 658-02-8079 | 2 | 13 | | 874-24-1805 | 1 | 15 | | 521-40-4757 | 4 | 20 | | 368-34-7197 | 2 | 29 | | 449-14-0909 | 4 | 10 | | 521-40-4757 | 3 | 28 | | 874-24-1805 | 3 | 33 | | 874-24-1805 | 4 | 0 | | 626-86-0981 | 4 | 43 | | 259-69-3521 | 2 | 38 | | 855-68-5051 | 1 | 32 | | 640-78-3450 | 2 | 23 | | 486-81-9989 | 2 | 3 | | 600-82-6063 | 3 | 40 | | 250-42-9823 | 1 | 24 | | 626-86-0981 | 3 | 24 | | 368-34-7197 | 1 | 39 | | 356-90-7571 | 3 | 42 | | 532-76-3517 | 4 | 13 | | 414-10-4271 | 4 | 20 | | 447-39-2466 | 3 | 2 | | 206-42-6778 | 1 | 19 | | 803-13-5063 | 3 | 4 | | 375-34-0891 | 2 | 41 | | 785-69-1449 | 2 | 48 | | 533-85-8477 | 2 | 14 | | 439-93-4732 | 2 | 46 | | 799-59-0118 | 3 | 33 | | 663-54-0337 | 2 | 20 | | 463-13-5723 | 3 | 15 | | 357-26-8858 | 2 | 10 | | 169-88-1613 | 3 | 25 | | 259-67-9909 | 3 | 37 | | 799-59-0118 | 2 | 8 | | 442-52-4791 | 1 | 21 | | 259-67-9909 | 4 | 37 | | 440-89-5164 | 3 | 50 | | 279-97-0698 | 2 | 24 | | 720-58-9192 | 4 | 14 | | 755-49-5779 | 1 | 13 | | 850-85-0292 | 4 | 17 | | 676-04-3191 | 1 | 4 | | 155-65-2686 | 2 | 47 | | 785-69-1449 | 4 | 18 | | 688-21-1512 | 3 | 40 | | 486-81-9989 | 4 | 48 | | 676-04-3191 | 2 | 16 | | 449-14-0909 | 3 | 12 | | 581-28-8564 | 2 | 11 | | 218-15-2428 | 3 | 9 | | 730-73-1824 | 3 | 45 | | 725-13-9144 | 3 | 16 | | 439-93-4732 | 1 | 32 | | 536-16-5537 | 1 | 44 | | 476-67-1971 | 3 | 3 | | 521-52-7799 | 4 | 24 | | 532-76-3517 | 3 | 10 | | 543-29-8929 | 1 | 40 | | 543-29-8929 | 4 | 7 | | 279-97-0698 | 4 | 30 | | 803-13-5063 | 2 | 50 | | 484-58-1616 | 3 | 34 | | 489-86-9980 | 4 | 13 | | 311-57-2543 | 3 | 30 | | 649-68-0970 | 1 | 3 | | 407-66-4296 | 2 | 45 | | 622-30-0735 | 4 | 6 | | 515-40-9765 | 3 | 36 | | 180-68-1912 | 3 | 23 | | 252-70-1281 | 4 | 16 | | 169-88-1613 | 1 | 48 | | 575-99-5872 | 4 | 8 | | 521-40-4757 | 1 | 40 | | 414-10-4271 | 1 | 11 | | 369-50-5680 | 3 | 8 | | 769-08-1237 | 2 | 46 | | 861-96-0479 | 3 | 6 | | 369-50-5680 | 4 | 15 | | 327-45-5907 | 1 | 43 | | 799-59-0118 | 4 | 1 | | 831-68-7820 | 2 | 16 | | 548-58-9075 | 3 | 16 | | 785-69-1449 | 3 | 49 | | 536-16-5537 | 2 | 31 | | 645-74-0526 | 3 | 4 | | 850-85-0292 | 3 | 21 | | 279-97-0698 | 1 | 33 | | 735-36-0902 | 4 | 49 | | 442-52-4791 | 2 | 11 | | 688-21-1512 | 4 | 28 | | 803-13-5063 | 4 | 43 | | 248-16-5831 | 2 | 30 | | 608-12-4879 | 2 | 48 | | 608-12-4879 | 4 | 34 | | 663-54-0337 | 4 | 13 | | 259-69-3521 | 4 | 2 | | 740-55-0204 | 4 | 46 | | 893-15-9265 | 4 | 31 | | 785-69-1449 | 1 | 33 | | 658-02-8079 | 4 | 42 | | 665-86-8548 | 3 | 11 | | 532-76-3517 | 1 | 13 | | 740-55-0204 | 3 | 26 | | 645-89-3504 | 1 | 9 | | 327-45-5907 | 4 | 30 | | 740-55-0204 | 1 | 36 | | 665-86-8548 | 1 | 50 | | 221-78-4352 | 4 | 28 | | 548-58-9075 | 1 | 30 | | 581-28-8564 | 3 | 31 | | 250-45-6366 | 1 | 10 | | 600-82-6063 | 4 | 11 | | 663-54-0337 | 3 | 8 | | 206-42-6778 | 4 | 12 | | 489-86-9980 | 3 | 22 | | 357-26-8858 | 3 | 40 | | 467-54-3176 | 3 | 21 | | 368-34-7197 | 4 | 4 | | 615-18-6818 | 4 | 30 | | 543-29-8929 | 3 | 42 | | 440-89-5164 | 4 | 19 | | 717-85-9172 | 4 | 29 | | 108-30-6419 | 2 | 19 | | 515-40-9765 | 2 | 17 | | 622-30-0735 | 1 | 27 | | 252-70-1281 | 1 | 7 | | 259-69-3521 | 3 | 12 | | 645-74-0526 | 1 | 41 | | 855-68-5051 | 3 | 12 | | 108-30-6419 | 4 | 19 | | 801-55-5158 | 3 | 42 | | 301-24-1567 | 2 | 19 | | 596-37-9209 | 3 | 2 | | 649-68-0970 | 4 | 23 | | 439-93-4732 | 4 | 36 | | 310-24-7033 | 1 | 45 | | 735-36-0902 | 3 | 9 | | 484-58-1616 | 1 | 1 | | 356-90-7571 | 2 | 37 | | 301-24-1567 | 3 | 30 | | 112-77-5572 | 4 | 14 | | 134-43-6596 | 2 | 33 | | 489-86-9980 | 2 | 49 | | 788-79-8433 | 3 | 45 | | 788-79-8433 | 1 | 11 | | 414-10-4271 | 3 | 15 | | 112-77-5572 | 3 | 31 | | 442-52-4791 | 4 | 29 | | 467-54-3176 | 2 | 0 | | 440-89-5164 | 2 | 38 | | 252-70-1281 | 3 | 2 | | 609-89-7019 | 1 | 26 | | 519-28-6669 | 3 | 49 | | 368-34-7197 | 3 | 9 | | 575-99-3134 | 4 | 34 | | 250-86-3243 | 3 | 49 | | 489-86-9980 | 1 | 39 | | 827-84-9853 | 4 | 13 | | 224-05-5365 | 1 | 27 | | 157-88-7908 | 3 | 29 | | 740-55-0204 | 2 | 10 | | 224-05-5365 | 3 | 25 | | 788-79-8433 | 2 | 32 | | 645-89-3504 | 2 | 13 | | 108-30-6419 | 3 | 43 | | 717-85-9172 | 2 | 14 | | 862-55-5133 | 1 | 3 | | 407-66-4296 | 4 | 30 | | 157-88-7908 | 4 | 44 | | 414-10-4271 | 2 | 42 | | 250-86-3243 | 2 | 32 | | 730-73-1824 | 4 | 26 | | 829-82-9898 | 3 | 15 | | 369-50-5680 | 2 | 10 | | 788-79-8433 | 4 | 23 | | 755-49-5779 | 3 | 33 | | 717-85-9172 | 1 | 32 | | 658-02-8079 | 1 | 21 | | 575-99-5872 | 3 | 34 | | 575-99-3134 | 3 | 45 | | 829-82-9898 | 2 | 13 | | 484-58-1616 | 4 | 7 | | 665-86-8548 | 2 | 31 | | 851-37-9880 | 4 | 8 | | 178-09-9074 | 4 | 38 | | 725-13-9144 | 1 | 36 | | 180-68-1912 | 2 | 21 | | 622-30-0735 | 3 | 13 | | 195-36-4688 | 2 | 18 | | 218-15-2428 | 1 | 19 | | 801-55-5158 | 4 | 28 | | 829-82-9898 | 1 | 29 | | 407-66-4296 | 3 | 31 | | 526-92-5991 | 4 | 46 | | 596-37-9209 | 2 | 44 | | 199-45-7914 | 2 | 8 | | 831-68-7820 | 4 | 42 | | 508-50-6186 | 1 | 17 | | 608-12-4879 | 1 | 23 | | 874-24-1805 | 2 | 20 | | 108-30-6419 | 1 | 4 | | 301-24-1567 | 4 | 4 | | 521-52-7799 | 2 | 50 | | 467-54-3176 | 4 | 14 | | 375-34-0891 | 3 | 50 | | 112-77-5572 | 1 | 24 | | 301-24-1567 | 1 | 6 | | 861-96-0479 | 4 | 29 | | 221-78-4352 | 2 | 40 | | 827-84-9853 | 2 | 38 | | 169-88-1613 | 2 | 12 | | 199-45-7914 | 1 | 48 | | 575-99-5872 | 1 | 43 | | 356-90-7571 | 1 | 20 | | 862-55-5133 | 4 | 18 | | 831-68-7820 | 3 | 30 | | 645-74-0526 | 4 | 7 | | 134-43-6596 | 4 | 35 | | 615-18-6818 | 2 | 40 | | 755-49-5779 | 4 | 41 | | 310-24-7033 | 3 | 9 | | 799-59-0118 | 1 | 13 | | 180-68-1912 | 1 | 28 | | 521-40-4757 | 2 | 21 | | 622-30-0735 | 2 | 16 | | 645-89-3504 | 3 | 43 | | 449-14-0909 | 2 | 3 | | 645-74-0526 | 2 | 14 | | 440-89-5164 | 1 | 35 | | 851-37-9880 | 3 | 41 | | 157-88-7908 | 1 | 36 | | 855-68-5051 | 2 | 5 | | 554-96-0793 | 4 | 19 | | 632-84-2428 | 4 | 12 | | 536-16-5537 | 4 | 4 | | 526-92-5991 | 2 | 1 | | 157-88-7908 | 2 | 7 | | 600-82-6063 | 1 | 35 | | 357-26-8858 | 4 | 33 | | 720-58-9192 | 1 | 33 | | 581-28-8564 | 1 | 10 | | 769-08-1237 | 3 | 2 | | 632-84-2428 | 1 | 9 | | 508-50-6186 | 2 | 11 | | 609-89-7019 | 3 | 4 | | 357-26-8858 | 1 | 19 | | 676-04-3191 | 4 | 34 | | 608-12-4879 | 3 | 2 | | 218-15-2428 | 2 | 4 | | 407-66-4296 | 1 | 8 | | 252-70-1281 | 2 | 47 | | 369-50-5680 | 1 | 25 | | 195-36-4688 | 4 | 48 | | 852-63-0193 | 2 | 1 | | 195-36-4688 | 1 | 50 | | 893-15-9265 | 3 | 12 | | 375-34-0891 | 4 | 4 | | 554-96-0793 | 1 | 39 | | 250-42-9823 | 2 | 21 | +-------------+---------+-------+ B400 rows in set (0.001 sec) BB BMariaDB [companys23]> select SSN, Pnumber, round(rand() * 50, a2 Hours from Employee JOIN Project order by rand(); +-------------+---------+-------+ | SSN | Pnumber | Hours | +-------------+---------+-------+ | 615-18-6818 | 1 | 32.52 | | 645-89-3504 | 4 | 12.99 | | 134-43-6596 | 3 | 40.02 | | 515-40-9765 | 1 | 14.31 | | 730-73-1824 | 1 | 36.29 | | 301-24-1567 | 4 | 42.46 | | 442-52-4791 | 3 | 42.38 | | 311-57-2543 | 4 | 49.26 | | 519-28-6669 | 3 | 37.32 | | 447-39-2466 | 3 | 6.13 | | 532-76-3517 | 1 | 18.63 | | 155-65-2686 | 2 | 29.46 | | 532-76-3517 | 2 | 23.47 | | 356-90-7571 | 4 | 13.32 | | 439-93-4732 | 3 | 31.65 | | 221-78-4352 | 3 | 8.96 | | 799-59-0118 | 1 | 35.73 | | 600-82-6063 | 1 | 39.99 | | 855-68-5051 | 4 | 6.91 | | 195-36-4688 | 2 | 37.37 | | 279-97-0698 | 3 | 25.55 | | 827-84-9853 | 2 | 32.64 | | 676-04-3191 | 2 | 44.31 | | 526-92-5991 | 2 | 14.38 | | 622-30-0735 | 4 | 3.08 | | 310-24-7033 | 3 | 0.47 | | 626-86-0981 | 3 | 14.29 | | 407-66-4296 | 2 | 38.16 | | 199-45-7914 | 3 | 3.43 | | 645-74-0526 | 4 | 29.67 | | 180-68-1912 | 3 | 8.73 | | 730-73-1824 | 3 | 11.95 | | 769-08-1237 | 3 | 47.61 | | 658-02-8079 | 4 | 1.30 | | 645-89-3504 | 1 | 12.57 | | 484-58-1616 | 2 | 4.68 | | 250-86-3243 | 3 | 30.75 | | 440-89-5164 | 1 | 26.98 | | 250-86-3243 | 2 | 13.67 | | 874-24-1805 | 4 | 46.70 | | 259-67-9909 | 2 | 5.72 | | 369-50-5680 | 3 | 36.89 | | 851-37-9880 | 1 | 15.39 | | 206-42-6778 | 2 | 5.81 | | 755-49-5779 | 1 | 8.26 | | 829-82-9898 | 1 | 23.02 | | 533-85-8477 | 4 | 23.16 | | 259-69-3521 | 1 | 31.60 | | 486-81-9989 | 4 | 35.41 | | 218-15-2428 | 1 | 25.24 | | 801-55-5158 | 2 | 20.50 | | 369-50-5680 | 4 | 15.63 | | 575-99-3134 | 4 | 2.75 | | 827-84-9853 | 3 | 35.09 | | 508-50-6186 | 2 | 3.68 | | 526-92-5991 | 1 | 13.76 | | 608-12-4879 | 1 | 37.26 | | 375-34-0891 | 3 | 17.78 | | 663-54-0337 | 1 | 23.77 | | 725-13-9144 | 4 | 6.46 | | 311-57-2543 | 1 | 34.68 | | 279-97-0698 | 1 | 28.31 | | 622-30-0735 | 2 | 29.99 | | 218-15-2428 | 4 | 14.52 | | 640-78-3450 | 4 | 33.19 | | 467-54-3176 | 2 | 9.95 | | 489-86-9980 | 4 | 14.23 | | 463-13-5723 | 1 | 48.83 | | 489-86-9980 | 3 | 23.45 | | 717-85-9172 | 1 | 40.45 | | 850-85-0292 | 2 | 12.40 | | 369-50-5680 | 2 | 46.19 | | 134-43-6596 | 4 | 19.75 | | 676-04-3191 | 4 | 5.78 | | 440-89-5164 | 3 | 36.20 | | 740-55-0204 | 4 | 20.07 | | 301-24-1567 | 3 | 10.62 | | 788-79-8433 | 1 | 39.66 | | 486-81-9989 | 2 | 40.82 | | 725-13-9144 | 2 | 30.29 | | 157-88-7908 | 1 | 14.73 | | 801-55-5158 | 4 | 37.35 | | 852-63-0193 | 2 | 3.76 | | 224-05-5365 | 4 | 22.98 | | 442-52-4791 | 4 | 26.26 | | 626-86-0981 | 2 | 16.93 | | 467-54-3176 | 1 | 25.87 | | 543-29-8929 | 1 | 48.88 | | 484-58-1616 | 3 | 39.19 | | 180-68-1912 | 1 | 32.15 | | 301-24-1567 | 2 | 28.57 | | 851-37-9880 | 4 | 10.07 | | 803-13-5063 | 2 | 13.27 | | 720-58-9192 | 3 | 7.15 | | 178-09-9074 | 4 | 46.37 | | 521-52-7799 | 4 | 0.34 | | 640-78-3450 | 1 | 19.04 | | 533-85-8477 | 1 | 18.60 | | 600-82-6063 | 3 | 21.80 | | 543-29-8929 | 4 | 15.87 | | 615-18-6818 | 4 | 15.28 | | 356-90-7571 | 2 | 24.15 | | 755-49-5779 | 3 | 35.08 | | 368-34-7197 | 1 | 12.90 | | 206-42-6778 | 3 | 49.15 | | 169-88-1613 | 2 | 43.49 | | 829-82-9898 | 2 | 2.34 | | 532-76-3517 | 3 | 47.49 | | 259-67-9909 | 3 | 0.76 | | 508-50-6186 | 1 | 2.43 | | 357-26-8858 | 4 | 6.62 | | 581-28-8564 | 3 | 2.24 | | 851-37-9880 | 3 | 12.69 | | 526-92-5991 | 3 | 28.85 | | 645-89-3504 | 2 | 33.77 | | 676-04-3191 | 3 | 39.84 | | 769-08-1237 | 4 | 6.70 | | 608-12-4879 | 4 | 14.63 | | 199-45-7914 | 1 | 12.91 | | 554-96-0793 | 3 | 36.22 | | 259-67-9909 | 1 | 5.55 | | 368-34-7197 | 2 | 12.58 | | 521-52-7799 | 2 | 27.09 | | 554-96-0793 | 4 | 17.36 | | 536-16-5537 | 4 | 4.85 | | 788-79-8433 | 3 | 5.59 | | 368-34-7197 | 3 | 43.80 | | 626-86-0981 | 4 | 11.94 | | 862-55-5133 | 2 | 16.19 | | 851-37-9880 | 2 | 2.81 | | 248-16-5831 | 1 | 7.85 | | 221-78-4352 | 4 | 36.40 | | 199-45-7914 | 2 | 20.77 | | 649-68-0970 | 3 | 16.68 | | 486-81-9989 | 1 | 31.34 | | 720-58-9192 | 4 | 47.40 | | 855-68-5051 | 1 | 0.81 | | 195-36-4688 | 4 | 40.91 | | 755-49-5779 | 2 | 43.14 | | 533-85-8477 | 3 | 20.47 | | 827-84-9853 | 1 | 29.28 | | 575-99-5872 | 2 | 38.31 | | 279-97-0698 | 4 | 7.01 | | 375-34-0891 | 4 | 37.19 | | 259-69-3521 | 2 | 18.79 | | 688-21-1512 | 1 | 36.55 | | 199-45-7914 | 4 | 4.58 | | 484-58-1616 | 4 | 22.19 | | 463-13-5723 | 4 | 48.85 | | 250-42-9823 | 4 | 31.43 | | 108-30-6419 | 3 | 4.52 | | 375-34-0891 | 1 | 35.22 | | 521-40-4757 | 2 | 11.10 | | 874-24-1805 | 2 | 6.86 | | 327-45-5907 | 3 | 37.36 | | 178-09-9074 | 3 | 24.05 | | 414-10-4271 | 1 | 18.93 | | 799-59-0118 | 3 | 39.40 | | 788-79-8433 | 4 | 31.50 | | 508-50-6186 | 4 | 43.45 | | 250-86-3243 | 4 | 3.23 | | 658-02-8079 | 1 | 23.22 | | 221-78-4352 | 1 | 15.82 | | 717-85-9172 | 3 | 48.74 | | 640-78-3450 | 3 | 26.65 | | 515-40-9765 | 4 | 12.54 | | 622-30-0735 | 1 | 3.17 | | 861-96-0479 | 3 | 1.77 | | 663-54-0337 | 2 | 19.00 | | 476-67-1971 | 1 | 30.38 | | 134-43-6596 | 1 | 24.63 | | 829-82-9898 | 3 | 0.50 | | 519-28-6669 | 4 | 39.17 | | 439-93-4732 | 1 | 28.04 | | 769-08-1237 | 1 | 5.91 | | 609-89-7019 | 1 | 42.72 | | 725-13-9144 | 3 | 17.29 | | 440-89-5164 | 4 | 27.84 | | 893-15-9265 | 1 | 29.11 | | 735-36-0902 | 2 | 29.17 | | 615-18-6818 | 3 | 17.47 | | 250-45-6366 | 4 | 31.19 | | 852-63-0193 | 4 | 15.55 | | 134-43-6596 | 2 | 3.57 | | 740-55-0204 | 2 | 2.62 | | 310-24-7033 | 2 | 4.05 | | 740-55-0204 | 1 | 25.41 | | 575-99-5872 | 4 | 17.22 | | 206-42-6778 | 1 | 21.11 | | 476-67-1971 | 2 | 23.77 | | 108-30-6419 | 4 | 0.58 | | 893-15-9265 | 2 | 29.01 | | 521-52-7799 | 1 | 36.60 | | 250-42-9823 | 1 | 38.03 | | 414-10-4271 | 2 | 22.98 | | 369-50-5680 | 1 | 5.64 | | 440-89-5164 | 2 | 36.15 | | 799-59-0118 | 4 | 14.49 | | 755-49-5779 | 4 | 48.29 | | 893-15-9265 | 3 | 37.01 | | 250-42-9823 | 3 | 10.20 | | 645-89-3504 | 3 | 24.69 | | 310-24-7033 | 1 | 44.66 | | 368-34-7197 | 4 | 38.35 | | 439-93-4732 | 4 | 43.54 | | 467-54-3176 | 3 | 47.80 | | 486-81-9989 | 3 | 6.90 | | 250-86-3243 | 1 | 49.74 | | 801-55-5158 | 1 | 37.68 | | 874-24-1805 | 3 | 10.05 | | 447-39-2466 | 2 | 16.00 | | 622-30-0735 | 3 | 42.07 | | 596-37-9209 | 3 | 5.85 | | 649-68-0970 | 2 | 39.31 | | 536-16-5537 | 3 | 18.10 | | 688-21-1512 | 4 | 24.19 | | 717-85-9172 | 4 | 13.11 | | 665-86-8548 | 3 | 12.22 | | 785-69-1449 | 2 | 46.12 | | 536-16-5537 | 2 | 21.67 | | 169-88-1613 | 3 | 5.92 | | 608-12-4879 | 2 | 42.59 | | 301-24-1567 | 1 | 36.47 | | 575-99-3134 | 3 | 2.23 | | 407-66-4296 | 1 | 26.07 | | 447-39-2466 | 4 | 21.99 | | 596-37-9209 | 2 | 42.07 | | 449-14-0909 | 4 | 22.53 | | 180-68-1912 | 4 | 44.34 | | 449-14-0909 | 1 | 22.51 | | 831-68-7820 | 4 | 25.77 | | 632-84-2428 | 1 | 34.92 | | 112-77-5572 | 3 | 18.34 | | 449-14-0909 | 2 | 25.50 | | 855-68-5051 | 2 | 24.02 | | 252-70-1281 | 3 | 26.93 | | 852-63-0193 | 1 | 32.41 | | 279-97-0698 | 2 | 28.35 | | 893-15-9265 | 4 | 12.68 | | 735-36-0902 | 3 | 12.52 | | 850-85-0292 | 1 | 14.21 | | 375-34-0891 | 2 | 39.60 | | 730-73-1824 | 2 | 19.08 | | 850-85-0292 | 4 | 10.02 | | 730-73-1824 | 4 | 44.51 | | 609-89-7019 | 2 | 7.50 | | 581-28-8564 | 4 | 46.24 | | 195-36-4688 | 3 | 41.80 | | 608-12-4879 | 3 | 27.54 | | 645-74-0526 | 1 | 29.38 | | 259-67-9909 | 4 | 39.77 | | 519-28-6669 | 2 | 38.94 | | 725-13-9144 | 1 | 10.27 | | 862-55-5133 | 3 | 8.14 | | 665-86-8548 | 2 | 24.23 | | 862-55-5133 | 4 | 22.16 | | 663-54-0337 | 3 | 0.60 | | 407-66-4296 | 3 | 43.24 | | 221-78-4352 | 2 | 49.29 | | 803-13-5063 | 4 | 31.32 | | 861-96-0479 | 4 | 8.10 | | 688-21-1512 | 3 | 16.73 | | 735-36-0902 | 4 | 43.53 | | 463-13-5723 | 3 | 43.90 | | 649-68-0970 | 4 | 14.48 | | 803-13-5063 | 3 | 20.25 | | 548-58-9075 | 4 | 38.45 | | 543-29-8929 | 3 | 26.49 | | 248-16-5831 | 3 | 17.89 | | 356-90-7571 | 3 | 38.88 | | 720-58-9192 | 1 | 13.03 | | 252-70-1281 | 1 | 38.59 | | 801-55-5158 | 3 | 3.36 | | 327-45-5907 | 2 | 3.75 | | 108-30-6419 | 2 | 13.67 | | 855-68-5051 | 3 | 44.26 | | 645-74-0526 | 3 | 18.85 | | 442-52-4791 | 1 | 42.11 | | 224-05-5365 | 2 | 48.11 | | 484-58-1616 | 1 | 24.11 | | 521-40-4757 | 1 | 8.65 | | 327-45-5907 | 4 | 37.11 | | 414-10-4271 | 4 | 15.44 | | 489-86-9980 | 1 | 42.32 | | 157-88-7908 | 3 | 28.09 | | 575-99-5872 | 1 | 15.43 | | 548-58-9075 | 1 | 7.33 | | 717-85-9172 | 2 | 35.09 | | 600-82-6063 | 2 | 13.50 | | 676-04-3191 | 1 | 12.83 | | 720-58-9192 | 2 | 33.36 | | 548-58-9075 | 3 | 32.59 | | 596-37-9209 | 1 | 49.35 | | 311-57-2543 | 3 | 8.21 | | 831-68-7820 | 3 | 49.70 | | 850-85-0292 | 3 | 45.39 | | 862-55-5133 | 1 | 28.31 | | 195-36-4688 | 1 | 15.55 | | 169-88-1613 | 1 | 0.56 | | 463-13-5723 | 2 | 38.61 | | 180-68-1912 | 2 | 3.04 | | 206-42-6778 | 4 | 23.46 | | 575-99-5872 | 3 | 22.88 | | 645-74-0526 | 2 | 49.26 | | 476-67-1971 | 4 | 47.22 | | 831-68-7820 | 1 | 38.44 | | 259-69-3521 | 3 | 34.41 | | 785-69-1449 | 1 | 41.07 | | 852-63-0193 | 3 | 31.44 | | 521-52-7799 | 3 | 11.60 | | 615-18-6818 | 2 | 47.63 | | 769-08-1237 | 2 | 24.10 | | 581-28-8564 | 2 | 6.23 | | 250-45-6366 | 2 | 1.62 | | 248-16-5831 | 4 | 22.90 | | 596-37-9209 | 4 | 49.27 | | 632-84-2428 | 4 | 43.30 | | 554-96-0793 | 2 | 46.97 | | 861-96-0479 | 1 | 0.28 | | 532-76-3517 | 4 | 44.27 | | 224-05-5365 | 3 | 7.29 | | 259-69-3521 | 4 | 8.06 | | 785-69-1449 | 4 | 29.78 | | 357-26-8858 | 2 | 33.20 | | 688-21-1512 | 2 | 30.76 | | 224-05-5365 | 1 | 26.50 | | 327-45-5907 | 1 | 11.26 | | 521-40-4757 | 4 | 28.36 | | 252-70-1281 | 2 | 40.45 | | 157-88-7908 | 2 | 31.47 | | 250-45-6366 | 3 | 0.06 | | 665-86-8548 | 4 | 10.90 | | 439-93-4732 | 2 | 24.92 | | 112-77-5572 | 1 | 13.54 | | 449-14-0909 | 3 | 31.77 | | 640-78-3450 | 2 | 9.23 | | 543-29-8929 | 2 | 11.54 | | 169-88-1613 | 4 | 7.82 | | 519-28-6669 | 1 | 39.48 | | 155-65-2686 | 4 | 25.43 | | 575-99-3134 | 1 | 26.69 | | 250-45-6366 | 1 | 10.12 | | 827-84-9853 | 4 | 26.11 | | 112-77-5572 | 2 | 41.46 | | 112-77-5572 | 4 | 24.39 | | 414-10-4271 | 3 | 47.67 | | 803-13-5063 | 1 | 42.42 | | 157-88-7908 | 4 | 24.42 | | 155-65-2686 | 3 | 30.85 | | 658-02-8079 | 2 | 15.79 | | 575-99-3134 | 2 | 11.95 | | 252-70-1281 | 4 | 4.62 | | 357-26-8858 | 3 | 21.29 | | 831-68-7820 | 2 | 43.77 | | 665-86-8548 | 1 | 14.76 | | 311-57-2543 | 2 | 23.76 | | 626-86-0981 | 1 | 39.99 | | 600-82-6063 | 4 | 3.86 | | 447-39-2466 | 1 | 22.43 | | 861-96-0479 | 2 | 1.30 | | 554-96-0793 | 1 | 20.32 | | 609-89-7019 | 3 | 4.23 | | 740-55-0204 | 3 | 19.12 | | 108-30-6419 | 1 | 21.92 | | 356-90-7571 | 1 | 47.67 | | 548-58-9075 | 2 | 14.67 | | 178-09-9074 | 2 | 41.65 | | 489-86-9980 | 2 | 39.55 | | 248-16-5831 | 2 | 14.42 | | 874-24-1805 | 1 | 8.94 | | 663-54-0337 | 4 | 12.26 | | 536-16-5537 | 1 | 41.17 | | 658-02-8079 | 3 | 38.34 | | 788-79-8433 | 2 | 41.53 | | 310-24-7033 | 4 | 2.95 | | 407-66-4296 | 4 | 9.09 | | 467-54-3176 | 4 | 10.15 | | 357-26-8858 | 1 | 21.40 | | 632-84-2428 | 2 | 8.46 | | 178-09-9074 | 1 | 21.03 | | 521-40-4757 | 3 | 5.64 | | 649-68-0970 | 1 | 15.09 | | 218-15-2428 | 3 | 43.46 | | 508-50-6186 | 3 | 28.81 | | 829-82-9898 | 4 | 21.55 | | 526-92-5991 | 4 | 49.38 | | 735-36-0902 | 1 | 5.32 | | 533-85-8477 | 2 | 22.57 | | 218-15-2428 | 2 | 48.64 | | 609-89-7019 | 4 | 15.37 | | 632-84-2428 | 3 | 21.05 | | 785-69-1449 | 3 | 8.29 | | 799-59-0118 | 2 | 3.67 | | 515-40-9765 | 2 | 9.56 | | 581-28-8564 | 1 | 35.82 | | 515-40-9765 | 3 | 18.76 | | 476-67-1971 | 3 | 26.64 | | 155-65-2686 | 1 | 28.19 | | 442-52-4791 | 2 | 19.93 | | 250-42-9823 | 2 | 4.90 | +-------------+---------+-------+ B400 rows in set (0.001 sec) BB 50ariaDB [companys23]> select SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rand();limit 1 50; +-------------+---------+-------+ | SSN | Pnumber | Hours | +-------------+---------+-------+ | 489-86-9980 | 1 | 11.22 | | 195-36-4688 | 1 | 45.74 | | 548-58-9075 | 2 | 42.89 | | 632-84-2428 | 1 | 49.18 | | 735-36-0902 | 2 | 47.95 | | 803-13-5063 | 1 | 41.40 | | 600-82-6063 | 2 | 16.11 | | 250-86-3243 | 4 | 39.91 | | 575-99-3134 | 4 | 6.58 | | 852-63-0193 | 3 | 41.14 | | 112-77-5572 | 1 | 33.84 | | 717-85-9172 | 2 | 45.74 | | 801-55-5158 | 3 | 31.61 | | 622-30-0735 | 3 | 1.02 | | 311-57-2543 | 4 | 13.58 | | 414-10-4271 | 4 | 38.75 | | 224-05-5365 | 2 | 20.98 | | 827-84-9853 | 1 | 18.24 | | 221-78-4352 | 2 | 31.53 | | 250-42-9823 | 2 | 14.28 | | 740-55-0204 | 3 | 4.33 | | 645-74-0526 | 3 | 27.85 | | 850-85-0292 | 4 | 32.97 | | 440-89-5164 | 2 | 44.56 | | 248-16-5831 | 3 | 41.77 | | 447-39-2466 | 1 | 8.25 | | 855-68-5051 | 4 | 39.82 | | 279-97-0698 | 4 | 48.96 | | 575-99-5872 | 4 | 28.14 | | 615-18-6818 | 1 | 16.27 | | 658-02-8079 | 4 | 30.57 | | 575-99-5872 | 1 | 12.77 | | 533-85-8477 | 2 | 7.97 | | 609-89-7019 | 3 | 1.73 | | 640-78-3450 | 1 | 33.56 | | 645-74-0526 | 4 | 2.07 | | 581-28-8564 | 1 | 18.78 | | 803-13-5063 | 4 | 48.38 | | 893-15-9265 | 3 | 43.22 | | 180-68-1912 | 1 | 28.39 | | 447-39-2466 | 3 | 9.88 | | 799-59-0118 | 1 | 29.33 | | 640-78-3450 | 4 | 25.55 | | 676-04-3191 | 4 | 38.79 | | 195-36-4688 | 3 | 25.87 | | 536-16-5537 | 1 | 1.31 | | 874-24-1805 | 2 | 21.03 | | 248-16-5831 | 4 | 10.17 | | 862-55-5133 | 4 | 41.70 | | 489-86-9980 | 4 | 45.14 | | 575-99-5872 | 3 | 19.90 | | 221-78-4352 | 4 | 44.06 | | 861-96-0479 | 2 | 47.56 | | 608-12-4879 | 3 | 16.02 | | 521-52-7799 | 4 | 45.43 | | 850-85-0292 | 2 | 32.04 | | 717-85-9172 | 1 | 31.77 | | 369-50-5680 | 1 | 39.03 | | 252-70-1281 | 2 | 21.32 | | 221-78-4352 | 1 | 45.07 | | 829-82-9898 | 3 | 45.85 | | 259-69-3521 | 3 | 32.59 | | 862-55-5133 | 1 | 45.30 | | 519-28-6669 | 3 | 7.98 | | 357-26-8858 | 2 | 10.87 | | 467-54-3176 | 2 | 31.80 | | 596-37-9209 | 1 | 48.05 | | 157-88-7908 | 3 | 0.91 | | 178-09-9074 | 1 | 16.04 | | 199-45-7914 | 3 | 8.46 | | 486-81-9989 | 4 | 28.77 | | 178-09-9074 | 4 | 40.60 | | 755-49-5779 | 1 | 46.75 | | 442-52-4791 | 3 | 16.21 | | 467-54-3176 | 1 | 40.21 | | 543-29-8929 | 2 | 2.93 | | 108-30-6419 | 3 | 9.34 | | 851-37-9880 | 1 | 38.59 | | 489-86-9980 | 3 | 20.70 | | 199-45-7914 | 2 | 26.48 | | 788-79-8433 | 3 | 42.93 | | 489-86-9980 | 2 | 6.68 | | 608-12-4879 | 1 | 22.48 | | 521-52-7799 | 3 | 21.68 | | 799-59-0118 | 2 | 30.09 | | 521-52-7799 | 2 | 6.87 | | 301-24-1567 | 2 | 38.40 | | 663-54-0337 | 3 | 16.58 | | 665-86-8548 | 4 | 34.26 | | 831-68-7820 | 1 | 9.44 | | 893-15-9265 | 2 | 26.67 | | 827-84-9853 | 2 | 13.10 | | 740-55-0204 | 2 | 36.51 | | 600-82-6063 | 4 | 46.22 | | 521-40-4757 | 3 | 14.35 | | 596-37-9209 | 3 | 16.94 | | 665-86-8548 | 3 | 46.23 | | 755-49-5779 | 4 | 12.24 | | 218-15-2428 | 4 | 42.43 | | 155-65-2686 | 2 | 31.82 | | 157-88-7908 | 1 | 42.07 | | 311-57-2543 | 2 | 12.64 | | 730-73-1824 | 2 | 46.38 | | 663-54-0337 | 4 | 43.63 | | 649-68-0970 | 4 | 19.90 | | 626-86-0981 | 1 | 9.75 | | 369-50-5680 | 3 | 40.66 | | 688-21-1512 | 1 | 15.22 | | 640-78-3450 | 2 | 33.47 | | 543-29-8929 | 4 | 28.84 | | 327-45-5907 | 4 | 16.56 | | 645-89-3504 | 3 | 21.80 | | 250-42-9823 | 1 | 35.09 | | 874-24-1805 | 4 | 18.68 | | 407-66-4296 | 1 | 15.08 | | 688-21-1512 | 2 | 42.96 | | 310-24-7033 | 2 | 0.53 | | 861-96-0479 | 1 | 15.47 | | 250-42-9823 | 3 | 22.82 | | 626-86-0981 | 2 | 42.92 | | 248-16-5831 | 1 | 39.11 | | 788-79-8433 | 1 | 3.81 | | 463-13-5723 | 2 | 22.37 | | 440-89-5164 | 3 | 34.43 | | 548-58-9075 | 3 | 39.92 | | 626-86-0981 | 4 | 41.09 | | 310-24-7033 | 3 | 19.11 | | 250-45-6366 | 4 | 3.17 | | 224-05-5365 | 1 | 14.21 | | 515-40-9765 | 1 | 4.45 | | 801-55-5158 | 2 | 9.16 | | 250-45-6366 | 3 | 2.65 | | 769-08-1237 | 1 | 45.66 | | 112-77-5572 | 4 | 22.67 | | 169-88-1613 | 3 | 40.46 | | 874-24-1805 | 1 | 31.54 | | 463-13-5723 | 1 | 44.37 | | 134-43-6596 | 1 | 47.75 | | 649-68-0970 | 2 | 17.91 | | 301-24-1567 | 3 | 14.50 | | 252-70-1281 | 1 | 46.15 | | 199-45-7914 | 4 | 21.62 | | 769-08-1237 | 2 | 33.88 | | 357-26-8858 | 4 | 41.73 | | 720-58-9192 | 4 | 39.25 | | 609-89-7019 | 1 | 17.72 | | 356-90-7571 | 3 | 18.91 | | 785-69-1449 | 3 | 20.91 | | 536-16-5537 | 2 | 46.36 | | 769-08-1237 | 3 | 38.25 | | 414-10-4271 | 3 | 43.84 | | 484-58-1616 | 3 | 39.28 | | 375-34-0891 | 1 | 19.25 | | 554-96-0793 | 4 | 47.02 | | 596-37-9209 | 4 | 48.82 | | 521-40-4757 | 1 | 19.68 | | 112-77-5572 | 2 | 26.08 | | 831-68-7820 | 4 | 16.66 | | 851-37-9880 | 4 | 29.24 | | 108-30-6419 | 4 | 16.46 | | 543-29-8929 | 1 | 43.90 | | 301-24-1567 | 1 | 38.19 | | 526-92-5991 | 2 | 8.98 | | 279-97-0698 | 1 | 22.37 | | 169-88-1613 | 2 | 44.74 | | 755-49-5779 | 3 | 13.22 | | 893-15-9265 | 4 | 23.73 | | 609-89-7019 | 2 | 22.64 | | 615-18-6818 | 2 | 29.27 | | 206-42-6778 | 3 | 31.18 | | 861-96-0479 | 3 | 7.24 | | 407-66-4296 | 3 | 48.13 | | 449-14-0909 | 4 | 16.55 | | 581-28-8564 | 3 | 14.71 | | 155-65-2686 | 1 | 31.78 | | 476-67-1971 | 1 | 30.96 | | 486-81-9989 | 2 | 18.04 | | 615-18-6818 | 4 | 6.61 | | 463-13-5723 | 3 | 38.41 | | 533-85-8477 | 4 | 3.72 | | 134-43-6596 | 2 | 48.40 | | 449-14-0909 | 2 | 9.14 | | 476-67-1971 | 3 | 13.11 | | 532-76-3517 | 2 | 29.05 | | 658-02-8079 | 3 | 0.96 | | 206-42-6778 | 1 | 38.34 | | 855-68-5051 | 3 | 26.37 | | 649-68-0970 | 1 | 45.59 | | 645-89-3504 | 4 | 1.34 | | 259-67-9909 | 1 | 43.23 | | 622-30-0735 | 1 | 21.74 | | 327-45-5907 | 3 | 16.13 | | 515-40-9765 | 3 | 8.57 | | 484-58-1616 | 2 | 17.26 | | 515-40-9765 | 2 | 18.25 | | 199-45-7914 | 1 | 37.14 | | 439-93-4732 | 2 | 0.67 | | 250-45-6366 | 2 | 6.90 | | 740-55-0204 | 1 | 23.68 | | 717-85-9172 | 3 | 30.40 | | 720-58-9192 | 3 | 15.16 | | 112-77-5572 | 3 | 41.48 | | 851-37-9880 | 3 | 45.81 | | 375-34-0891 | 2 | 22.10 | | 735-36-0902 | 1 | 10.80 | | 310-24-7033 | 1 | 29.92 | | 250-86-3243 | 1 | 5.01 | | 554-96-0793 | 1 | 48.64 | | 626-86-0981 | 3 | 45.78 | | 799-59-0118 | 3 | 35.08 | | 108-30-6419 | 2 | 26.71 | | 206-42-6778 | 4 | 11.47 | | 310-24-7033 | 4 | 37.88 | | 852-63-0193 | 4 | 21.48 | | 369-50-5680 | 4 | 13.53 | | 108-30-6419 | 1 | 9.56 | | 831-68-7820 | 2 | 31.57 | | 463-13-5723 | 4 | 48.51 | | 250-86-3243 | 3 | 42.13 | | 720-58-9192 | 1 | 49.42 | | 442-52-4791 | 2 | 7.54 | | 688-21-1512 | 3 | 4.76 | | 134-43-6596 | 3 | 40.39 | | 155-65-2686 | 3 | 40.77 | | 725-13-9144 | 3 | 9.30 | | 180-68-1912 | 4 | 2.70 | | 486-81-9989 | 3 | 33.75 | | 600-82-6063 | 3 | 40.14 | | 467-54-3176 | 4 | 18.09 | | 536-16-5537 | 3 | 0.58 | | 224-05-5365 | 4 | 47.31 | | 195-36-4688 | 4 | 3.26 | | 676-04-3191 | 2 | 24.37 | | 803-13-5063 | 2 | 46.62 | | 533-85-8477 | 3 | 17.92 | | 608-12-4879 | 2 | 38.28 | | 157-88-7908 | 4 | 16.18 | | 447-39-2466 | 2 | 38.09 | | 521-52-7799 | 1 | 28.48 | | 519-28-6669 | 4 | 44.27 | | 575-99-3134 | 2 | 24.22 | | 368-34-7197 | 3 | 25.29 | | 831-68-7820 | 3 | 49.98 | | 788-79-8433 | 4 | 33.36 | | 519-28-6669 | 1 | 33.19 | | 515-40-9765 | 4 | 32.01 | | 532-76-3517 | 3 | 8.57 | | 554-96-0793 | 2 | 5.69 | | 476-67-1971 | 2 | 31.98 | | 508-50-6186 | 4 | 24.50 | +-------------+---------+-------+ B250 rows in set (0.002 sec) BB 50;riaDB [companys23]> select SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rand() limit 25 +-------------+---------+-------+ | SSN | Pnumber | Hours | +-------------+---------+-------+ | 463-13-5723 | 3 | 49.90 | | 440-89-5164 | 3 | 34.14 | | 581-28-8564 | 4 | 48.88 | | 575-99-3134 | 3 | 36.20 | | 608-12-4879 | 2 | 35.36 | | 632-84-2428 | 2 | 27.31 | | 785-69-1449 | 1 | 25.65 | | 407-66-4296 | 1 | 36.07 | | 515-40-9765 | 1 | 26.24 | | 609-89-7019 | 1 | 23.84 | | 521-40-4757 | 3 | 49.45 | | 720-58-9192 | 3 | 44.28 | | 769-08-1237 | 2 | 11.39 | | 224-05-5365 | 2 | 8.19 | | 730-73-1824 | 2 | 45.47 | | 596-37-9209 | 2 | 2.23 | | 447-39-2466 | 1 | 18.08 | | 827-84-9853 | 1 | 4.20 | | 649-68-0970 | 3 | 14.20 | | 157-88-7908 | 1 | 31.07 | | 717-85-9172 | 4 | 26.25 | | 112-77-5572 | 4 | 47.32 | | 855-68-5051 | 3 | 45.02 | | 543-29-8929 | 4 | 14.03 | | 311-57-2543 | 1 | 45.33 | | 615-18-6818 | 1 | 41.03 | | 769-08-1237 | 3 | 30.03 | | 740-55-0204 | 3 | 3.46 | | 439-93-4732 | 4 | 38.50 | | 467-54-3176 | 1 | 21.31 | | 259-69-3521 | 2 | 44.92 | | 206-42-6778 | 3 | 37.02 | | 476-67-1971 | 4 | 13.93 | | 735-36-0902 | 4 | 47.37 | | 533-85-8477 | 1 | 44.20 | | 368-34-7197 | 1 | 39.09 | | 463-13-5723 | 1 | 43.94 | | 645-89-3504 | 2 | 37.15 | | 608-12-4879 | 4 | 22.52 | | 407-66-4296 | 2 | 39.30 | | 533-85-8477 | 2 | 20.64 | | 600-82-6063 | 1 | 33.94 | | 626-86-0981 | 3 | 5.15 | | 250-45-6366 | 2 | 38.76 | | 851-37-9880 | 4 | 24.61 | | 199-45-7914 | 4 | 1.32 | | 449-14-0909 | 3 | 27.64 | | 221-78-4352 | 2 | 25.56 | | 414-10-4271 | 4 | 46.09 | | 861-96-0479 | 1 | 27.99 | | 596-37-9209 | 3 | 24.27 | | 486-81-9989 | 2 | 49.82 | | 250-42-9823 | 1 | 7.25 | | 536-16-5537 | 4 | 32.76 | | 785-69-1449 | 3 | 37.22 | | 600-82-6063 | 4 | 31.95 | | 855-68-5051 | 1 | 6.19 | | 301-24-1567 | 4 | 29.06 | | 851-37-9880 | 2 | 10.24 | | 486-81-9989 | 1 | 12.71 | | 369-50-5680 | 4 | 0.36 | | 755-49-5779 | 1 | 16.51 | | 755-49-5779 | 2 | 9.94 | | 250-45-6366 | 4 | 45.18 | | 489-86-9980 | 2 | 20.92 | | 645-74-0526 | 1 | 49.74 | | 735-36-0902 | 3 | 27.19 | | 134-43-6596 | 2 | 24.24 | | 508-50-6186 | 2 | 1.32 | | 788-79-8433 | 3 | 20.81 | | 463-13-5723 | 4 | 9.41 | | 788-79-8433 | 2 | 6.58 | | 536-16-5537 | 1 | 16.32 | | 609-89-7019 | 3 | 20.98 | | 476-67-1971 | 2 | 1.45 | | 688-21-1512 | 1 | 14.80 | | 788-79-8433 | 1 | 32.95 | | 526-92-5991 | 2 | 38.38 | | 725-13-9144 | 2 | 4.29 | | 632-84-2428 | 4 | 25.43 | | 626-86-0981 | 2 | 6.33 | | 439-93-4732 | 3 | 39.25 | | 250-86-3243 | 1 | 12.48 | | 862-55-5133 | 3 | 28.01 | | 248-16-5831 | 2 | 40.56 | | 157-88-7908 | 2 | 44.78 | | 861-96-0479 | 2 | 24.08 | | 533-85-8477 | 4 | 16.76 | | 803-13-5063 | 4 | 34.19 | | 180-68-1912 | 3 | 22.97 | | 221-78-4352 | 3 | 24.39 | | 310-24-7033 | 1 | 3.44 | | 649-68-0970 | 4 | 45.74 | | 851-37-9880 | 1 | 17.48 | | 740-55-0204 | 2 | 36.98 | | 855-68-5051 | 4 | 34.81 | | 665-86-8548 | 4 | 30.99 | | 827-84-9853 | 3 | 29.88 | | 178-09-9074 | 4 | 43.74 | | 658-02-8079 | 1 | 32.40 | | 862-55-5133 | 4 | 40.50 | | 221-78-4352 | 4 | 17.91 | | 640-78-3450 | 1 | 40.92 | | 725-13-9144 | 1 | 10.56 | | 874-24-1805 | 1 | 22.51 | | 108-30-6419 | 2 | 10.25 | | 301-24-1567 | 1 | 18.30 | | 755-49-5779 | 4 | 8.34 | | 720-58-9192 | 4 | 15.00 | | 206-42-6778 | 1 | 6.55 | | 850-85-0292 | 1 | 34.30 | | 622-30-0735 | 4 | 49.80 | | 615-18-6818 | 3 | 36.44 | | 169-88-1613 | 1 | 42.97 | | 301-24-1567 | 3 | 49.49 | | 195-36-4688 | 4 | 21.95 | | 543-29-8929 | 2 | 20.40 | | 626-86-0981 | 4 | 29.45 | | 414-10-4271 | 2 | 25.78 | | 218-15-2428 | 2 | 31.08 | | 581-28-8564 | 3 | 9.49 | | 740-55-0204 | 1 | 33.34 | | 596-37-9209 | 1 | 31.79 | | 622-30-0735 | 2 | 17.23 | | 717-85-9172 | 1 | 28.51 | | 368-34-7197 | 2 | 7.61 | | 199-45-7914 | 1 | 9.25 | | 575-99-5872 | 1 | 46.21 | | 548-58-9075 | 4 | 11.41 | | 439-93-4732 | 1 | 8.85 | | 608-12-4879 | 1 | 49.16 | | 250-45-6366 | 1 | 29.95 | | 515-40-9765 | 2 | 43.06 | | 665-86-8548 | 1 | 40.84 | | 543-29-8929 | 3 | 11.34 | | 440-89-5164 | 2 | 38.73 | | 730-73-1824 | 1 | 3.35 | | 720-58-9192 | 1 | 31.20 | | 259-69-3521 | 3 | 39.45 | | 615-18-6818 | 2 | 41.38 | | 827-84-9853 | 4 | 12.07 | | 609-89-7019 | 4 | 5.53 | | 252-70-1281 | 2 | 6.84 | | 801-55-5158 | 4 | 23.18 | | 799-59-0118 | 2 | 7.88 | | 827-84-9853 | 2 | 41.50 | | 467-54-3176 | 2 | 14.05 | | 526-92-5991 | 3 | 14.14 | | 311-57-2543 | 3 | 4.68 | | 831-68-7820 | 1 | 35.59 | | 356-90-7571 | 2 | 28.13 | | 508-50-6186 | 1 | 43.54 | | 548-58-9075 | 2 | 47.87 | | 447-39-2466 | 3 | 9.25 | | 108-30-6419 | 3 | 2.71 | | 803-13-5063 | 1 | 22.06 | | 134-43-6596 | 4 | 21.61 | | 829-82-9898 | 1 | 44.23 | | 799-59-0118 | 4 | 23.26 | | 218-15-2428 | 3 | 41.42 | | 252-70-1281 | 4 | 23.41 | | 489-86-9980 | 1 | 29.41 | | 250-86-3243 | 2 | 34.48 | | 799-59-0118 | 1 | 3.78 | | 250-42-9823 | 4 | 14.96 | | 134-43-6596 | 1 | 4.04 | | 279-97-0698 | 4 | 49.80 | | 311-57-2543 | 4 | 6.12 | | 508-50-6186 | 4 | 12.80 | | 831-68-7820 | 2 | 18.84 | | 356-90-7571 | 4 | 34.48 | | 663-54-0337 | 2 | 36.86 | | 169-88-1613 | 3 | 8.47 | | 862-55-5133 | 2 | 23.29 | | 725-13-9144 | 4 | 13.12 | | 440-89-5164 | 1 | 28.84 | | 801-55-5158 | 2 | 27.75 | | 596-37-9209 | 4 | 2.02 | | 829-82-9898 | 3 | 14.97 | | 195-36-4688 | 3 | 6.21 | | 626-86-0981 | 1 | 44.81 | | 250-86-3243 | 3 | 48.77 | | 645-89-3504 | 1 | 0.07 | | 543-29-8929 | 1 | 32.91 | | 484-58-1616 | 1 | 20.47 | | 640-78-3450 | 4 | 31.07 | | 829-82-9898 | 4 | 21.53 | | 735-36-0902 | 1 | 23.67 | | 248-16-5831 | 1 | 39.92 | | 861-96-0479 | 4 | 25.05 | | 554-96-0793 | 4 | 28.66 | | 526-92-5991 | 4 | 35.00 | | 463-13-5723 | 2 | 33.40 | | 515-40-9765 | 3 | 33.21 | | 649-68-0970 | 1 | 35.59 | | 521-40-4757 | 4 | 41.97 | | 310-24-7033 | 3 | 13.97 | | 195-36-4688 | 2 | 47.57 | | 250-42-9823 | 2 | 19.10 | | 730-73-1824 | 4 | 3.98 | | 658-02-8079 | 3 | 6.63 | | 665-86-8548 | 2 | 21.26 | | 785-69-1449 | 2 | 15.01 | | 730-73-1824 | 3 | 28.05 | | 221-78-4352 | 1 | 46.08 | | 852-63-0193 | 3 | 19.75 | | 532-76-3517 | 1 | 23.32 | | 467-54-3176 | 3 | 24.77 | | 526-92-5991 | 1 | 8.52 | | 195-36-4688 | 1 | 46.61 | | 248-16-5831 | 3 | 47.11 | | 645-74-0526 | 3 | 27.23 | | 645-89-3504 | 3 | 8.94 | | 717-85-9172 | 2 | 42.19 | | 259-69-3521 | 1 | 10.01 | | 850-85-0292 | 2 | 42.81 | | 155-65-2686 | 4 | 11.23 | | 301-24-1567 | 2 | 37.42 | | 575-99-5872 | 3 | 45.88 | | 608-12-4879 | 3 | 19.11 | | 785-69-1449 | 4 | 49.78 | | 311-57-2543 | 2 | 8.41 | | 442-52-4791 | 1 | 13.25 | | 180-68-1912 | 4 | 11.18 | | 735-36-0902 | 2 | 37.03 | | 645-74-0526 | 4 | 32.19 | | 575-99-3134 | 4 | 22.13 | | 688-21-1512 | 3 | 26.40 | | 407-66-4296 | 4 | 27.05 | | 250-42-9823 | 3 | 28.12 | | 519-28-6669 | 4 | 3.60 | | 259-69-3521 | 4 | 7.11 | | 893-15-9265 | 2 | 5.53 | | 375-34-0891 | 2 | 22.95 | | 515-40-9765 | 4 | 9.43 | | 554-96-0793 | 2 | 2.55 | | 740-55-0204 | 4 | 38.79 | | 663-54-0337 | 3 | 29.48 | | 279-97-0698 | 3 | 23.75 | | 169-88-1613 | 4 | 13.09 | | 658-02-8079 | 4 | 45.30 | | 180-68-1912 | 2 | 9.14 | | 442-52-4791 | 2 | 14.12 | | 874-24-1805 | 4 | 25.61 | | 755-49-5779 | 3 | 13.75 | | 449-14-0909 | 4 | 35.06 | | 250-45-6366 | 3 | 29.85 | | 676-04-3191 | 1 | 33.48 | | 112-77-5572 | 1 | 38.16 | | 112-77-5572 | 2 | 5.70 | +-------------+---------+-------+ B250 rows in set (0.001 sec) BB 50;riaDB [companys23]> select SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rand() limit 25 +-------------+---------+-------+ | SSN | Pnumber | Hours | +-------------+---------+-------+ | 543-29-8929 | 1 | 19.59 | | 250-86-3243 | 2 | 5.64 | | 609-89-7019 | 4 | 4.08 | | 199-45-7914 | 1 | 0.14 | | 157-88-7908 | 4 | 40.21 | | 862-55-5133 | 3 | 7.80 | | 526-92-5991 | 4 | 1.44 | | 221-78-4352 | 4 | 3.01 | | 248-16-5831 | 3 | 44.48 | | 218-15-2428 | 4 | 36.63 | | 852-63-0193 | 3 | 0.28 | | 449-14-0909 | 4 | 43.54 | | 827-84-9853 | 3 | 13.38 | | 663-54-0337 | 4 | 33.87 | | 178-09-9074 | 2 | 12.47 | | 439-93-4732 | 4 | 3.20 | | 476-67-1971 | 1 | 35.59 | | 615-18-6818 | 2 | 26.41 | | 676-04-3191 | 2 | 49.20 | | 259-67-9909 | 3 | 16.25 | | 740-55-0204 | 3 | 20.50 | | 526-92-5991 | 2 | 12.97 | | 596-37-9209 | 4 | 38.01 | | 575-99-5872 | 3 | 1.26 | | 626-86-0981 | 1 | 37.46 | | 357-26-8858 | 4 | 23.50 | | 178-09-9074 | 3 | 31.91 | | 112-77-5572 | 3 | 41.67 | | 532-76-3517 | 1 | 19.20 | | 640-78-3450 | 1 | 12.14 | | 665-86-8548 | 3 | 36.22 | | 279-97-0698 | 1 | 28.08 | | 407-66-4296 | 1 | 0.78 | | 449-14-0909 | 1 | 23.16 | | 250-45-6366 | 4 | 19.21 | | 632-84-2428 | 4 | 11.71 | | 526-92-5991 | 3 | 33.47 | | 855-68-5051 | 2 | 9.38 | | 310-24-7033 | 4 | 34.14 | | 169-88-1613 | 4 | 32.06 | | 508-50-6186 | 3 | 8.87 | | 862-55-5133 | 4 | 38.32 | | 195-36-4688 | 1 | 42.08 | | 356-90-7571 | 3 | 37.03 | | 178-09-9074 | 4 | 33.90 | | 533-85-8477 | 4 | 33.28 | | 252-70-1281 | 3 | 22.83 | | 357-26-8858 | 2 | 9.00 | | 368-34-7197 | 2 | 19.89 | | 785-69-1449 | 4 | 10.13 | | 311-57-2543 | 2 | 5.82 | | 622-30-0735 | 4 | 1.91 | | 310-24-7033 | 2 | 28.27 | | 665-86-8548 | 2 | 44.53 | | 688-21-1512 | 3 | 33.55 | | 486-81-9989 | 2 | 26.33 | | 463-13-5723 | 4 | 6.59 | | 195-36-4688 | 2 | 39.27 | | 543-29-8929 | 3 | 12.76 | | 486-81-9989 | 4 | 35.48 | | 519-28-6669 | 2 | 7.38 | | 439-93-4732 | 2 | 27.74 | | 440-89-5164 | 4 | 37.57 | | 769-08-1237 | 3 | 1.17 | | 676-04-3191 | 4 | 5.31 | | 134-43-6596 | 3 | 39.02 | | 688-21-1512 | 1 | 47.40 | | 369-50-5680 | 2 | 38.06 | | 720-58-9192 | 1 | 24.69 | | 554-96-0793 | 2 | 28.69 | | 829-82-9898 | 1 | 4.48 | | 252-70-1281 | 4 | 29.35 | | 717-85-9172 | 3 | 33.33 | | 536-16-5537 | 2 | 2.60 | | 543-29-8929 | 2 | 7.33 | | 449-14-0909 | 2 | 18.85 | | 581-28-8564 | 2 | 49.09 | | 600-82-6063 | 3 | 21.18 | | 799-59-0118 | 4 | 34.86 | | 645-89-3504 | 1 | 12.35 | | 221-78-4352 | 2 | 42.78 | | 785-69-1449 | 3 | 8.72 | | 311-57-2543 | 3 | 36.39 | | 108-30-6419 | 2 | 30.27 | | 717-85-9172 | 2 | 38.55 | | 548-58-9075 | 4 | 13.92 | | 206-42-6778 | 3 | 14.12 | | 663-54-0337 | 2 | 4.36 | | 803-13-5063 | 1 | 31.50 | | 645-74-0526 | 3 | 49.57 | | 645-89-3504 | 3 | 36.76 | | 311-57-2543 | 4 | 8.24 | | 486-81-9989 | 3 | 30.98 | | 658-02-8079 | 2 | 27.13 | | 874-24-1805 | 2 | 41.87 | | 861-96-0479 | 4 | 21.92 | | 851-37-9880 | 3 | 12.29 | | 508-50-6186 | 4 | 34.43 | | 735-36-0902 | 1 | 44.33 | | 688-21-1512 | 4 | 21.56 | | 440-89-5164 | 3 | 29.77 | | 250-42-9823 | 2 | 43.36 | | 827-84-9853 | 1 | 23.48 | | 515-40-9765 | 4 | 4.26 | | 801-55-5158 | 3 | 30.41 | | 665-86-8548 | 1 | 17.11 | | 463-13-5723 | 2 | 46.43 | | 769-08-1237 | 1 | 43.94 | | 157-88-7908 | 1 | 38.39 | | 626-86-0981 | 2 | 13.26 | | 521-40-4757 | 4 | 43.48 | | 622-30-0735 | 1 | 9.59 | | 486-81-9989 | 1 | 49.76 | | 375-34-0891 | 4 | 36.87 | | 199-45-7914 | 2 | 45.16 | | 259-69-3521 | 4 | 34.88 | | 521-52-7799 | 4 | 27.25 | | 369-50-5680 | 3 | 8.08 | | 575-99-5872 | 4 | 35.87 | | 447-39-2466 | 3 | 49.61 | | 449-14-0909 | 3 | 16.31 | | 112-77-5572 | 4 | 14.91 | | 440-89-5164 | 2 | 11.47 | | 414-10-4271 | 3 | 32.57 | | 279-97-0698 | 3 | 9.68 | | 250-86-3243 | 1 | 47.57 | | 532-76-3517 | 2 | 36.34 | | 369-50-5680 | 1 | 49.32 | | 327-45-5907 | 3 | 40.19 | | 519-28-6669 | 3 | 5.70 | | 581-28-8564 | 3 | 31.01 | | 645-74-0526 | 4 | 37.35 | | 327-45-5907 | 2 | 12.55 | | 720-58-9192 | 2 | 44.57 | | 855-68-5051 | 1 | 16.29 | | 439-93-4732 | 3 | 48.24 | | 608-12-4879 | 1 | 47.43 | | 259-67-9909 | 1 | 14.45 | | 554-96-0793 | 3 | 47.56 | | 250-45-6366 | 1 | 1.03 | | 554-96-0793 | 4 | 21.96 | | 874-24-1805 | 4 | 22.95 | | 248-16-5831 | 4 | 5.42 | | 632-84-2428 | 3 | 17.15 | | 463-13-5723 | 1 | 42.09 | | 252-70-1281 | 2 | 1.95 | | 301-24-1567 | 4 | 44.64 | | 108-30-6419 | 3 | 1.19 | | 311-57-2543 | 1 | 33.42 | | 414-10-4271 | 2 | 14.08 | | 357-26-8858 | 1 | 31.93 | | 301-24-1567 | 2 | 9.17 | | 755-49-5779 | 3 | 7.22 | | 519-28-6669 | 4 | 42.72 | | 526-92-5991 | 1 | 1.59 | | 484-58-1616 | 2 | 46.00 | | 788-79-8433 | 3 | 9.74 | | 740-55-0204 | 2 | 32.09 | | 476-67-1971 | 4 | 39.10 | | 850-85-0292 | 1 | 37.40 | | 581-28-8564 | 4 | 33.52 | | 575-99-3134 | 3 | 41.37 | | 725-13-9144 | 4 | 38.50 | | 735-36-0902 | 2 | 45.62 | | 688-21-1512 | 2 | 33.03 | | 218-15-2428 | 3 | 39.87 | | 735-36-0902 | 3 | 11.38 | | 609-89-7019 | 2 | 37.95 | | 521-40-4757 | 3 | 1.42 | | 831-68-7820 | 3 | 6.70 | | 649-68-0970 | 4 | 1.12 | | 327-45-5907 | 4 | 5.35 | | 608-12-4879 | 2 | 12.18 | | 155-65-2686 | 2 | 42.03 | | 169-88-1613 | 3 | 10.44 | | 155-65-2686 | 1 | 37.97 | | 658-02-8079 | 1 | 42.60 | | 439-93-4732 | 1 | 3.67 | | 368-34-7197 | 1 | 10.51 | | 180-68-1912 | 2 | 9.94 | | 508-50-6186 | 1 | 25.80 | | 259-67-9909 | 4 | 19.99 | | 581-28-8564 | 1 | 37.53 | | 861-96-0479 | 2 | 48.50 | | 874-24-1805 | 3 | 38.95 | | 803-13-5063 | 4 | 20.09 | | 310-24-7033 | 3 | 29.88 | | 615-18-6818 | 3 | 36.70 | | 484-58-1616 | 3 | 28.41 | | 861-96-0479 | 1 | 46.43 | | 851-37-9880 | 2 | 16.50 | | 489-86-9980 | 3 | 29.61 | | 407-66-4296 | 3 | 18.50 | | 554-96-0793 | 1 | 37.62 | | 861-96-0479 | 3 | 24.30 | | 788-79-8433 | 2 | 28.27 | | 248-16-5831 | 2 | 4.91 | | 755-49-5779 | 1 | 10.34 | | 221-78-4352 | 1 | 34.93 | | 649-68-0970 | 3 | 6.42 | | 447-39-2466 | 4 | 33.00 | | 725-13-9144 | 3 | 7.54 | | 626-86-0981 | 3 | 35.87 | | 720-58-9192 | 3 | 44.20 | | 717-85-9172 | 1 | 44.29 | | 134-43-6596 | 2 | 17.04 | | 609-89-7019 | 1 | 15.51 | | 195-36-4688 | 3 | 11.28 | | 218-15-2428 | 2 | 19.45 | | 615-18-6818 | 4 | 46.12 | | 521-40-4757 | 2 | 49.62 | | 893-15-9265 | 1 | 13.29 | | 626-86-0981 | 4 | 18.44 | | 862-55-5133 | 2 | 15.93 | | 224-05-5365 | 4 | 1.11 | | 180-68-1912 | 4 | 0.35 | | 259-69-3521 | 3 | 19.63 | | 788-79-8433 | 4 | 30.82 | | 108-30-6419 | 4 | 8.22 | | 442-52-4791 | 3 | 41.57 | | 224-05-5365 | 3 | 39.39 | | 831-68-7820 | 4 | 15.15 | | 155-65-2686 | 4 | 20.20 | | 827-84-9853 | 2 | 16.64 | | 622-30-0735 | 3 | 34.09 | | 224-05-5365 | 2 | 31.55 | | 357-26-8858 | 3 | 9.49 | | 852-63-0193 | 4 | 45.45 | | 467-54-3176 | 1 | 13.21 | | 519-28-6669 | 1 | 0.49 | | 250-86-3243 | 3 | 22.79 | | 250-42-9823 | 3 | 9.89 | | 279-97-0698 | 4 | 6.56 | | 827-84-9853 | 4 | 22.53 | | 375-34-0891 | 3 | 40.00 | | 600-82-6063 | 4 | 25.43 | | 755-49-5779 | 4 | 13.42 | | 248-16-5831 | 1 | 10.89 | | 252-70-1281 | 1 | 39.53 | | 850-85-0292 | 4 | 34.56 | | 515-40-9765 | 1 | 20.22 | | 640-78-3450 | 3 | 22.03 | | 596-37-9209 | 2 | 34.08 | | 609-89-7019 | 3 | 34.36 | | 769-08-1237 | 4 | 17.09 | | 575-99-3134 | 2 | 1.75 | | 224-05-5365 | 1 | 43.28 | | 327-45-5907 | 1 | 32.13 | | 862-55-5133 | 1 | 29.12 | | 755-49-5779 | 2 | 12.00 | +-------------+---------+-------+ B250 rows in set (0.001 sec) BB 50;iselectcSSN,nPnumber,eround(rand()u*b50, r2)nasrHours from,EmployeeHJOIN Projectporder byIrand()elimitd250;nselect)SSN,iPnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rand() limit 250;select SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rand() limit 250;eselect SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rand() limit 250;rselect SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rand() limitselect SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rand() lim select SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rand() liiselect SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rand() lnselect SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rand() tselect SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rand()oselect SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rand( select SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by randWselect SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by ranoselect SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rarselect SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by rkselect SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order by select SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order byOselect SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order bnselect SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order select SSN, Pnumber, round(rand() * 50, 2) as Hours from Employee JOIN Project order BQuery OK, 250 rows affected (0.008 sec) BBRecords: 250 Duplicates: 0 Warnings: 0 BB BMariaDB [companys23]> select * from WorksOn; +-------------+---------+-------+ | SSN | Pnumber | Hours | +-------------+---------+-------+ | 108-30-6419 | 4 | 41.97 | | 112-77-5572 | 1 | 2.21 | | 112-77-5572 | 2 | 22.67 | | 112-77-5572 | 3 | 26.29 | | 112-77-5572 | 4 | 33.82 | | 134-43-6596 | 1 | 45.79 | | 134-43-6596 | 3 | 6.75 | | 134-43-6596 | 4 | 26.24 | | 155-65-2686 | 1 | 49.97 | | 155-65-2686 | 2 | 37.06 | | 155-65-2686 | 3 | 5.05 | | 155-65-2686 | 4 | 38.78 | | 157-88-7908 | 1 | 34.55 | | 157-88-7908 | 2 | 37.97 | | 157-88-7908 | 3 | 40.35 | | 169-88-1613 | 1 | 24.96 | | 169-88-1613 | 2 | 34.21 | | 169-88-1613 | 3 | 1.13 | | 178-09-9074 | 1 | 13.49 | | 178-09-9074 | 3 | 22.46 | | 178-09-9074 | 4 | 46.1 | | 180-68-1912 | 1 | 35.39 | | 180-68-1912 | 3 | 49.6 | | 195-36-4688 | 1 | 12.28 | | 195-36-4688 | 2 | 42.23 | | 195-36-4688 | 3 | 6.34 | | 195-36-4688 | 4 | 10.67 | | 199-45-7914 | 1 | 25.16 | | 199-45-7914 | 4 | 29.53 | | 206-42-6778 | 1 | 12.44 | | 206-42-6778 | 2 | 15.56 | | 206-42-6778 | 3 | 27.31 | | 206-42-6778 | 4 | 40.92 | | 218-15-2428 | 1 | 45.56 | | 218-15-2428 | 3 | 43.29 | | 218-15-2428 | 4 | 29.08 | | 221-78-4352 | 4 | 11.71 | | 224-05-5365 | 1 | 24.74 | | 224-05-5365 | 3 | 38.98 | | 248-16-5831 | 2 | 16.69 | | 248-16-5831 | 4 | 9.46 | | 250-42-9823 | 1 | 41.14 | | 250-42-9823 | 3 | 22.07 | | 250-45-6366 | 1 | 6.64 | | 250-45-6366 | 2 | 27.42 | | 250-45-6366 | 3 | 21.69 | | 250-45-6366 | 4 | 38.8 | | 250-86-3243 | 1 | 8.49 | | 250-86-3243 | 2 | 15.12 | | 250-86-3243 | 4 | 12.71 | | 252-70-1281 | 2 | 33.65 | | 259-69-3521 | 1 | 28.86 | | 259-69-3521 | 2 | 39.96 | | 259-69-3521 | 3 | 35.62 | | 259-69-3521 | 4 | 2.62 | | 301-24-1567 | 1 | 15.37 | | 301-24-1567 | 2 | 0.2 | | 301-24-1567 | 3 | 32.9 | | 301-24-1567 | 4 | 46.76 | | 310-24-7033 | 4 | 46.43 | | 311-57-2543 | 2 | 48.22 | | 311-57-2543 | 3 | 17.61 | | 311-57-2543 | 4 | 5.4 | | 327-45-5907 | 1 | 47.59 | | 356-90-7571 | 1 | 21.29 | | 356-90-7571 | 2 | 25.96 | | 356-90-7571 | 3 | 42.9 | | 357-26-8858 | 1 | 31.46 | | 357-26-8858 | 2 | 36.59 | | 357-26-8858 | 3 | 41.2 | | 357-26-8858 | 4 | 11.56 | | 368-34-7197 | 1 | 34.04 | | 368-34-7197 | 4 | 3.46 | | 369-50-5680 | 2 | 3.63 | | 369-50-5680 | 4 | 43.91 | | 375-34-0891 | 1 | 17.65 | | 375-34-0891 | 2 | 11.18 | | 375-34-0891 | 3 | 13.44 | | 375-34-0891 | 4 | 22.11 | | 407-66-4296 | 1 | 3.03 | | 407-66-4296 | 2 | 20.03 | | 407-66-4296 | 4 | 31.44 | | 414-10-4271 | 1 | 20.35 | | 414-10-4271 | 2 | 19.42 | | 414-10-4271 | 3 | 46.7 | | 439-93-4732 | 1 | 23.56 | | 439-93-4732 | 2 | 7.76 | | 439-93-4732 | 4 | 19.46 | | 440-89-5164 | 1 | 4.05 | | 440-89-5164 | 3 | 1.27 | | 440-89-5164 | 4 | 26.12 | | 442-52-4791 | 1 | 0.54 | | 447-39-2466 | 3 | 36.3 | | 447-39-2466 | 4 | 10.09 | | 449-14-0909 | 1 | 34.79 | | 449-14-0909 | 2 | 37.74 | | 449-14-0909 | 3 | 8.76 | | 463-13-5723 | 1 | 12.48 | | 463-13-5723 | 4 | 16.9 | | 467-54-3176 | 1 | 28.34 | | 467-54-3176 | 2 | 34.1 | | 467-54-3176 | 4 | 41.54 | | 476-67-1971 | 2 | 10.63 | | 476-67-1971 | 3 | 24.37 | | 476-67-1971 | 4 | 47.52 | | 484-58-1616 | 1 | 26.73 | | 484-58-1616 | 2 | 12.79 | | 484-58-1616 | 3 | 30.89 | | 486-81-9989 | 2 | 4.65 | | 486-81-9989 | 3 | 23.96 | | 486-81-9989 | 4 | 18.26 | | 489-86-9980 | 1 | 17.38 | | 489-86-9980 | 2 | 1.18 | | 508-50-6186 | 1 | 21.88 | | 508-50-6186 | 2 | 18.39 | | 508-50-6186 | 3 | 10.64 | | 508-50-6186 | 4 | 37.65 | | 515-40-9765 | 1 | 36.58 | | 515-40-9765 | 2 | 8.32 | | 515-40-9765 | 3 | 14.01 | | 519-28-6669 | 1 | 45.78 | | 519-28-6669 | 2 | 5.9 | | 519-28-6669 | 3 | 29.92 | | 521-40-4757 | 2 | 30.14 | | 521-40-4757 | 3 | 0.26 | | 521-40-4757 | 4 | 24.71 | | 521-52-7799 | 2 | 15.91 | | 521-52-7799 | 3 | 24.34 | | 521-52-7799 | 4 | 41.99 | | 526-92-5991 | 2 | 23.67 | | 526-92-5991 | 3 | 47.13 | | 526-92-5991 | 4 | 39.18 | | 532-76-3517 | 2 | 47.79 | | 532-76-3517 | 3 | 34.05 | | 532-76-3517 | 4 | 41.55 | | 533-85-8477 | 1 | 2.06 | | 533-85-8477 | 2 | 43.3 | | 533-85-8477 | 4 | 21.67 | | 536-16-5537 | 1 | 16.93 | | 536-16-5537 | 3 | 19.87 | | 536-16-5537 | 4 | 15.1 | | 543-29-8929 | 1 | 16.96 | | 543-29-8929 | 2 | 22.09 | | 543-29-8929 | 3 | 29.05 | | 543-29-8929 | 4 | 43.41 | | 548-58-9075 | 2 | 37.16 | | 548-58-9075 | 3 | 5.11 | | 548-58-9075 | 4 | 39 | | 554-96-0793 | 3 | 13.76 | | 575-99-3134 | 1 | 19.23 | | 575-99-3134 | 2 | 7.71 | | 575-99-3134 | 3 | 29.28 | | 575-99-3134 | 4 | 46.36 | | 575-99-5872 | 2 | 11.74 | | 575-99-5872 | 3 | 22.49 | | 575-99-5872 | 4 | 16.73 | | 581-28-8564 | 3 | 24.23 | | 596-37-9209 | 1 | 3.07 | | 596-37-9209 | 2 | 13.18 | | 600-82-6063 | 1 | 21.64 | | 608-12-4879 | 1 | 12.61 | | 608-12-4879 | 2 | 16.52 | | 608-12-4879 | 3 | 20.74 | | 608-12-4879 | 4 | 43.69 | | 609-89-7019 | 3 | 33.17 | | 609-89-7019 | 4 | 10.7 | | 622-30-0735 | 2 | 2.33 | | 632-84-2428 | 1 | 36.85 | | 632-84-2428 | 2 | 14.17 | | 632-84-2428 | 4 | 36.62 | | 640-78-3450 | 2 | 24.59 | | 640-78-3450 | 4 | 44.22 | | 645-74-0526 | 1 | 46.36 | | 645-74-0526 | 2 | 12.68 | | 645-74-0526 | 4 | 33.15 | | 645-89-3504 | 2 | 33.64 | | 645-89-3504 | 4 | 21.43 | | 649-68-0970 | 1 | 25.74 | | 658-02-8079 | 1 | 44.28 | | 658-02-8079 | 2 | 46.51 | | 658-02-8079 | 4 | 18.16 | | 663-54-0337 | 1 | 25.59 | | 663-54-0337 | 3 | 17.74 | | 663-54-0337 | 4 | 29.53 | | 665-86-8548 | 1 | 42.49 | | 665-86-8548 | 2 | 47.09 | | 665-86-8548 | 3 | 17.57 | | 676-04-3191 | 1 | 10.98 | | 676-04-3191 | 4 | 10.11 | | 688-21-1512 | 4 | 25.75 | | 717-85-9172 | 1 | 10.65 | | 717-85-9172 | 2 | 16.08 | | 717-85-9172 | 3 | 20.88 | | 720-58-9192 | 1 | 25.14 | | 720-58-9192 | 2 | 36.26 | | 720-58-9192 | 3 | 46.1 | | 720-58-9192 | 4 | 26.98 | | 725-13-9144 | 2 | 11.41 | | 725-13-9144 | 3 | 2.44 | | 730-73-1824 | 1 | 15.39 | | 730-73-1824 | 2 | 11.51 | | 730-73-1824 | 3 | 23.91 | | 730-73-1824 | 4 | 10.53 | | 735-36-0902 | 1 | 0.76 | | 735-36-0902 | 2 | 30.11 | | 735-36-0902 | 3 | 28.33 | | 735-36-0902 | 4 | 49.32 | | 740-55-0204 | 1 | 17.24 | | 740-55-0204 | 2 | 25.51 | | 755-49-5779 | 1 | 25.72 | | 755-49-5779 | 2 | 10.48 | | 755-49-5779 | 3 | 26.61 | | 769-08-1237 | 1 | 43.62 | | 769-08-1237 | 2 | 36.48 | | 769-08-1237 | 3 | 31.93 | | 785-69-1449 | 3 | 30.87 | | 785-69-1449 | 4 | 45.69 | | 788-79-8433 | 1 | 4.45 | | 799-59-0118 | 1 | 49.59 | | 799-59-0118 | 2 | 21.22 | | 799-59-0118 | 3 | 8.07 | | 801-55-5158 | 1 | 28.42 | | 801-55-5158 | 2 | 45.19 | | 801-55-5158 | 4 | 2.68 | | 803-13-5063 | 1 | 37.72 | | 803-13-5063 | 2 | 49.66 | | 803-13-5063 | 3 | 43.39 | | 827-84-9853 | 1 | 47.68 | | 827-84-9853 | 4 | 46 | | 829-82-9898 | 2 | 29.06 | | 831-68-7820 | 1 | 18.14 | | 831-68-7820 | 2 | 19.81 | | 831-68-7820 | 3 | 0.26 | | 850-85-0292 | 1 | 10.09 | | 850-85-0292 | 2 | 47.31 | | 850-85-0292 | 3 | 46.63 | | 852-63-0193 | 1 | 25.85 | | 852-63-0193 | 3 | 6.46 | | 855-68-5051 | 1 | 10.14 | | 855-68-5051 | 2 | 46.55 | | 855-68-5051 | 4 | 23.04 | | 861-96-0479 | 1 | 26.58 | | 861-96-0479 | 2 | 10.97 | | 862-55-5133 | 3 | 10.57 | | 862-55-5133 | 4 | 23.37 | | 874-24-1805 | 2 | 33.03 | | 874-24-1805 | 3 | 48.02 | | 874-24-1805 | 4 | 31.06 | | 893-15-9265 | 3 | 41.96 | | 893-15-9265 | 4 | 5.92 | +-------------+---------+-------+ B250 rows in set (0.001 sec) BB BMariaDB [companys23]> select count(*) from Employee; +----------+ | count(*) | +----------+ | 100 | +----------+ B1 row in set (0.001 sec) BB BMariaDB [companys23]> select count(distinctESSN)yfrom WorksOn; +---------------------+ | count(distinct SSN) | +---------------------+ | 95 | +---------------------+ B1 row in set (0.001 sec) BB BMariaDB [companys23]> select * from Employee where SSN NOT IN (select SSNtfrom WorksOn); +-------------+-----------+-------+------------+------------+--------------------+-----------+-------------+---------+ | SSN | Fname | Minit | Lname | Bdate | Address | Salary | Super_SSN | Dnumber | +-------------+-----------+-------+------------+------------+--------------------+-----------+-------------+---------+ | 259-67-9909 | Tanitansy | NULL | Fragino | 1957-01-28 | 17 Milwaukee Alley | 105180.00 | 622-30-0735 | 3 | | 279-97-0698 | Emilie | NULL | MacGahey | 1936-06-26 | 22 Shoshone Lane | 116060.00 | 301-24-1567 | 4 | | 615-18-6818 | Janean | NULL | Azam | 1914-10-14 | 83 Upham Drive | 26517.00 | 508-50-6186 | 1 | | 626-86-0981 | Hadley | NULL | Wallbutton | 1971-01-13 | 55 Elka Street | 55988.00 | 279-97-0698 | 4 | | 851-37-9880 | Aggie | NULL | Pruvost | 1959-06-07 | 750 Mayfield Plaza | 60655.00 | 484-58-1616 | 2 | +-------------+-----------+-------+------------+------------+--------------------+-----------+-------------+---------+ B5 rows in set (0.002 sec) BB BMariaDB [companys23]> describe Employee; +-----------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------+------+-----+---------+-------+ | SSN | char(11) | NO | PRI | NULL | | | Fname | varchar(20) | NO | | NULL | | | Minit | char(1) | YES | | NULL | | | Lname | varchar(20) | NO | | NULL | | | Bdate | date | YES | | NULL | | | Address | varchar(100) | YES | | NULL | | | Salary | decimal(14,2) | YES | | NULL | | | Super_SSN | char(11) | YES | MUL | NULL | | | Dnumber | int(11) | YES | MUL | NULL | | +-----------+---------------+------+-----+---------+-------+ B9 rows in set (0.001 sec) BB BMariaDB [companys23]> exit BBye Bnick@artemis:~/3420/company/s23$ cd .. nick@artemis:~/3420/company$ cd .. nick@artemis:~/3420$ ls -l total 244 -rwxr-xr-x 1 nick nick 209512 Oct 24 10:22 3420_trivia drwxr-xr-x 6 nick nick 4096 Mar 6 13:00 company drwx------ 2 nick nick 4096 Oct 10 13:17 company_tmp -rw-r--r-- 1 nick nick 6296 Mar 16 13:27 Employee.csv -rwxr-xr-x 1 nick nick 2024 Mar 16 13:29 insertgenerator_v2.py drwx------ 4 nick nick 4096 Mar 9 12:39 prev drwxr-xr-x 3 nick nick 4096 Mar 9 12:38 s23 drwx------ 2 nick nick 4096 Mar 9 12:39 scripts drwxr-xr-x 5 nick nick 4096 Dec 12 22:15 useraccountsdemo nick@artemis:~/3420$ ./insertgenerator_v2.py Employee.csv Columns: ['SSN', 'Fname', 'Lname', 'Bdate', 'Address', 'Salary']. Column str: SSN, Fname, Lname, Bdate, Address, Salary Done nick@artemis:~/3420$ ls -l total 260 -rwxr-xr-x 1 nick nick 209512 Oct 24 10:22 3420_trivia drwxr-xr-x 6 nick nick 4096 Mar 6 13:00 company drwx------ 2 nick nick 4096 Oct 10 13:17 company_tmp -rw-r--r-- 1 nick nick 15459 Mar 16 13:29 create_Employee.sql -rw-r--r-- 1 nick nick 6296 Mar 16 13:27 Employee.csv -rwxr-xr-x 1 nick nick 2024 Mar 16 13:29 insertgenerator_v2.py drwx------ 4 nick nick 4096 Mar 9 12:39 prev drwxr-xr-x 3 nick nick 4096 Mar 9 12:38 s23 drwx------ 2 nick nick 4096 Mar 9 12:39 scripts drwxr-xr-x 5 nick nick 4096 Dec 12 22:15 useraccountsdemo nick@artemis:~/3420$ exit logout Connection to artemis.cs.csub.edu closed. nick@Vaxis:~$ exit exit