Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: sakila actor
|   actor_id | first_name   | last_name    | last_update             |
|-----------:|:-------------|:-------------|:------------------------|
|          1 | PENELOPE     | GUINESS      | 2006-02-15 04:34:33.000 |
|          2 | NICK         | WAHLBERG     | 2006-02-15 04:34:33.000 |
|          3 | ED           | CHASE        | 2006-02-15 04:34:33.000 |
|          4 | JENNIFER     | DAVIS        | 2006-02-15 04:34:33.000 |
|          5 | JOHNNY       | LOLLOBRIGIDA | 2006-02-15 04:34:33.000 |
|          6 | BETTE        | NICHOLSON    | 2006-02-15 04:34:33.000 |
|          7 | GRACE        | MOSTEL       | 2006-02-15 04:34:33.000 |
|          8 | MATTHEW      | JOHANSSON    | 2006-02-15 04:34:33.000 |
|          9 | JOE          | SWANK        | 2006-02-15 04:34:33.000 |
|         10 | CHRISTIAN    | GABLE        | 2006-02-15 04:34:33.000 |


Table: sakila actor_info
|   actor_id | first_name   | last_name    | film_info                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
|-----------:|:-------------|:-------------|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|          1 | PENELOPE     | GUINESS      | Animation: ANACONDA CONFESSIONS; Children: LANGUAGE COWBOY; Classics: COLOR PHILADELPHIA, WESTWARD SEABISCUIT; Comedy: VERTIGO NORTHWEST; Documentary: ACADEMY DINOSAUR; Family: KING EVOLUTION, SPLASH GUMP; Foreign: MULHOLLAND BEAST; Games: BULWORTH COMMANDMENTS, HUMAN GRAFFITI; Horror: ELEPHANT TROJAN, LADY STAGE, RULES HUMAN; Music: WIZARD COLDBLOODED; New: ANGELS LIFE, OKLAHOMA JUMANJI; Sci-Fi: CHEAPER CLYDE; Sports: GLEAMING JAWBREAKER                                                                                                                                                             |
|          2 | NICK         | WAHLBERG     | Action: BULL SHAWSHANK; Animation: FIGHT JAWBREAKER; Children: JERSEY SASSY; Classics: DRACULA CRYSTAL, GILBERT PELICAN; Comedy: MALLRATS UNITED, RUSHMORE MERMAID; Documentary: ADAPTATION HOLES; Drama: WARDROBE PHANTOM; Family: APACHE DIVINE, CHISUM BEHAVIOR, INDIAN LOVE, MAGUIRE APACHE; Foreign: BABY HALL, HAPPINESS UNITED; Games: ROOF CHAMPION; Music: LUCKY FLYING; New: DESTINY SATURDAY, FLASH WARS, JEKYLL FROGMEN, MASK PEACH; Sci-Fi: CHAINSAW UPTOWN, GOODFELLAS SALUTE; Travel: LIAISONS SWEET, SMILE EARRING                                                                                     |
|          3 | ED           | CHASE        | Action: CADDYSHACK JEDI, FORREST SONS; Classics: FROST HEAD, JEEPERS WEDDING; Documentary: ARMY FLINTSTONES, FRENCH HOLIDAY, HALLOWEEN NUTS, HUNTER ALTER, WEDDING APOLLO, YOUNG LANGUAGE; Drama: LUCK OPUS, NECKLACE OUTBREAK, SPICE SORORITY; Foreign: COWBOY DOOM, WHALE BIKINI; Music: ALONE TRIP; New: EVE RESURRECTION, PLATOON INSTINCT; Sci-Fi: WEEKEND PERSONAL; Sports: ARTIST COLDBLOODED, IMAGE PRINCESS; Travel: BOONDOCK BALLROOM                                                                                                                                                                        |
|          4 | JENNIFER     | DAVIS        | Action: BAREFOOT MANCHURIAN; Animation: ANACONDA CONFESSIONS, GHOSTBUSTERS ELF; Comedy: SUBMARINE BED; Documentary: BED HIGHBALL, NATIONAL STORY, RAIDERS ANTITRUST; Drama: BLADE POLISH, GREEDY ROOTS; Family: SPLASH GUMP; Horror: TREASURE COMMAND; Music: HANOVER GALAXY, REDS POCUS; New: ANGELS LIFE, JUMANJI BLADE, OKLAHOMA JUMANJI; Sci-Fi: RANDOM GO, SILVERADO GOLDFINGER, UNFORGIVEN ZOOLANDER; Sports: INSTINCT AIRPORT, POSEIDON FOREVER; Travel: BOONDOCK BALLROOM                                                                                                                                      |
|          5 | JOHNNY       | LOLLOBRIGIDA | Action: AMADEUS HOLY, GRAIL FRANKENSTEIN, RINGS HEARTBREAKERS; Animation: SUNRISE LEAGUE; Children: HALL CASSIDY; Comedy: DADDY PITTSBURGH; Documentary: BONNIE HOLOCAUST, METAL ARMAGEDDON, PACIFIC AMISTAD, POCUS PULP; Drama: CHITTY LOCK, CONEHEADS SMOOCHY; Games: FIRE WOLVES; Horror: COMMANDMENTS EXPRESS, LOVE SUICIDES, PATTON INTERVIEW; Music: BANGER PINOCCHIO, HEAVENLY GUN; New: FRONTIER CABIN, RIDGEMONT SUBMARINE; Sci-Fi: DAISY MENAGERIE, GOODFELLAS SALUTE, SOLDIERS EVOLUTION; Sports: GROOVE FICTION, KRAMER CHOCOLATE, STAR OPERATION; Travel: ENOUGH RAGING, ESCAPE METROPOLIS, SMILE EARRING |
|          6 | BETTE        | NICHOLSON    | Action: ANTITRUST TOMATOES; Animation: BIKINI BORROWERS, CROSSROADS CASUALTIES, POTLUCK MIXED, TITANIC BOONDOCK; Children: LANGUAGE COWBOY; Classics: BEAST HUNCHBACK; Documentary: COAST RAINBOW; Family: BANG KWAI; Foreign: CALENDAR GUNFIGHT, MULHOLLAND BEAST; New: WYOMING STORM; Sci-Fi: COLDBLOODED DARLING; Sports: DROP WATERFRONT, KRAMER CHOCOLATE, LESSON CLEOPATRA, LIBERTY MAGNIFICENT, TRADING PINOCCHIO; Travel: IGBY MAKER, SPEED SUIT                                                                                                                                                               |
|          7 | GRACE        | MOSTEL       | Action: BERETS AGENT, EXCITEMENT EVE; Animation: SLEEPLESS MONSOON, TRACY CIDER; Children: WARLOCK WEREWOLF; Classics: MALKOVICH PET, OCTOBER SUBMARINE; Drama: CONFESSIONS MAGUIRE, DECEIVER BETRAYED, DESTINATION JERK, NECKLACE OUTBREAK, SAINTS BRIDE, SAVANNAH TOWN, TREATMENT JEKYLL; Foreign: COMMAND DARLING, HELLFIGHTERS SIERRA, SCISSORHANDS SLUMS, TOWN ARK, WAR NOTTING; Games: DAZED PUNK; Horror: ARACHNOPHOBIA ROLLERCOASTER, GASLIGHT CRUSADE; New: ANGELS LIFE, BREAKING HOME, SLEEPY JAPANESE, STING PERSONAL; Sci-Fi: OPEN AFRICAN; Sports: ANONYMOUS HUMAN, INSTINCT AIRPORT, POSEIDON FOREVER    |
|          8 | MATTHEW      | JOHANSSON    | Action: CAMPUS REMEMBER, DANCES NONE; Animation: SUGAR WONKA; Classics: LIGHTS DEER, MALKOVICH PET, TOMORROW HUSTLER; Drama: CONQUERER NUTS, HANGING DEEP, SCORPION APOLLO; Family: INDIAN LOVE; Foreign: BABY HALL, SCHOOL JACKET; Music: CLONES PINOCCHIO, DRIVING POLISH, RUNNER MADIGAN, VANISHING ROCKY; New: FLASH WARS; Sci-Fi: CROWDS TELEMARK; Sports: DURHAM PANKY, LOSER HUSTLER                                                                                                                                                                                                                            |
|          9 | JOE          | SWANK        | Action: PRIMARY GLASS, WATERFRONT DELIVERANCE; Animation: LAWLESS VISION, SUNRISE LEAGUE; Children: CROOKED FROGMEN, SWEETHEARTS SUSPECTS, TIES HUNGER; Classics: SNATCHERS MONTEZUMA; Documentary: MAJESTIC FLOATS, PACIFIC AMISTAD, UNTOUCHABLES SUNRISE; Drama: DALMATIONS SWEDEN, LEBOWSKI SOLDIERS; Family: CHOCOLAT HARRY; Foreign: CHOCOLATE DUCK; Games: CURTAIN VIDEOTAPE; Horror: ANYTHING SAVANNAH, REEF SALUTE; Music: BIRCH ANTITRUST, RUNNER MADIGAN; New: WILD APOLLO; Sports: PERDITION FARGO; Travel: HORROR REIGN, SMILE EARRING, TRAFFIC HOBBIT                                                     |
|         10 | CHRISTIAN    | GABLE        | Action: LORD ARIZONA, WATERFRONT DELIVERANCE; Animation: PUNK DIVORCE; Children: CROOKED FROGMEN; Classics: JEEPERS WEDDING, PREJUDICE OLEANDER; Comedy: LIFE TWISTED; Documentary: ACADEMY DINOSAUR, MOD SECRETARY, WEDDING APOLLO; Drama: GOLDFINGER SENSIBILITY; Foreign: USUAL UNTOUCHABLES; Games: DIVINE RESURRECTION; Horror: ALABAMA DEVIL, REAP UNFAITHFUL; Music: JAWBREAKER BROOKLYN, WIZARD COLDBLOODED, WON DARES; New: DRAGONFLY STRANGERS; Sci-Fi: VACATION BOONDOCK; Sports: SHAKESPEARE SADDLE; Travel: TROUBLE DATE                                                                                  |


Table: sakila address
|   address_id | address                            | address2   | district             |   city_id |   postal_code |        phone |                                           location | last_update             |
|-------------:|:-----------------------------------|:-----------|:---------------------|----------:|--------------:|-------------:|---------------------------------------------------:|:------------------------|
|           11 | 900 Santiago de Compostela Parkway |            | Central Serbia       |       280 |         93896 | 716571220373 | 00000000010100000000000000000000000000000000000000 | 2014-09-25 22:34:11.000 |
|           16 | 808 Bhopal Manor                   |            | Haryana              |       582 |         10672 | 465887807014 | 00000000010100000000000000000000000000000000000000 | 2014-09-25 22:31:30.000 |
|           24 | 1688 Okara Way                     |            | Nothwest Border Prov |       327 |         21954 | 144453869132 | 00000000010100000000000000000000000000000000000000 | 2014-09-25 22:32:30.000 |
|           26 | 28 Charlotte Amalie Street         |            | Rabat-Sal-Zammour-Z  |       443 |         37551 | 161968374323 | 00000000010100000000000000000000000000000000000000 | 2014-09-25 22:32:16.000 |
|           28 | 96 Tafuna Way                      |            | Crdoba               |       128 |         99865 | 934730187245 | 00000000010100000000000000000000000000000000000000 | 2014-09-25 22:30:05.000 |
|           30 | 18 Duisburg Boulevard              |            |                      |       121 |         58327 | 998009777982 | 00000000010100000000000000000000000000000000000000 | 2014-09-25 22:31:08.000 |
|           31 | 217 Botshabelo Place               |            | Southern Mindanao    |       138 |         49521 | 665356572025 | 00000000010100000000000000000000000000000000000000 | 2014-09-25 22:32:36.000 |
|           34 | 1668 Anpolis Street                |            | Taipei               |       316 |         50199 | 525255540978 | 00000000010100000000000000000000000000000000000000 | 2014-09-25 22:33:15.000 |
|           39 | 391 Callao Drive                   |            | Midi-Pyrnes          |       544 |         34021 | 440512153169 | 00000000010100000000000000000000000000000000000000 | 2014-09-25 22:31:01.000 |
|           43 | 306 Antofagasta Place              |            | Esprito Santo        |       569 |          3989 | 378318851631 | 00000000010100000000000000000000000000000000000000 | 2014-09-25 22:30:23.000 |


Table: sakila category
|   category_id | name        | last_update             |
|--------------:|:------------|:------------------------|
|             1 | Action      | 2006-02-15 04:46:27.000 |
|             2 | Animation   | 2006-02-15 04:46:27.000 |
|             3 | Children    | 2006-02-15 04:46:27.000 |
|             4 | Classics    | 2006-02-15 04:46:27.000 |
|             5 | Comedy      | 2006-02-15 04:46:27.000 |
|             6 | Documentary | 2006-02-15 04:46:27.000 |
|             7 | Drama       | 2006-02-15 04:46:27.000 |
|             8 | Family      | 2006-02-15 04:46:27.000 |
|             9 | Foreign     | 2006-02-15 04:46:27.000 |
|            10 | Games       | 2006-02-15 04:46:27.000 |


Table: sakila city
|   city_id | city               |   country_id | last_update             |
|----------:|:-------------------|-------------:|:------------------------|
|         1 | A Corua (La Corua) |           87 | 2006-02-15 04:45:25.000 |
|         2 | Abha               |           82 | 2006-02-15 04:45:25.000 |
|         3 | Abu Dhabi          |          101 | 2006-02-15 04:45:25.000 |
|         4 | Acua               |           60 | 2006-02-15 04:45:25.000 |
|         5 | Adana              |           97 | 2006-02-15 04:45:25.000 |
|         6 | Addis Abeba        |           31 | 2006-02-15 04:45:25.000 |
|         7 | Aden               |          107 | 2006-02-15 04:45:25.000 |
|         8 | Adoni              |           44 | 2006-02-15 04:45:25.000 |
|         9 | Ahmadnagar         |           44 | 2006-02-15 04:45:25.000 |
|        10 | Akishima           |           50 | 2006-02-15 04:45:25.000 |


Table: sakila country
|   country_id | country        | last_update             |
|-------------:|:---------------|:------------------------|
|            1 | Afghanistan    | 2006-02-15 04:44:00.000 |
|            2 | Algeria        | 2006-02-15 04:44:00.000 |
|            3 | American Samoa | 2006-02-15 04:44:00.000 |
|            4 | Angola         | 2006-02-15 04:44:00.000 |
|            5 | Anguilla       | 2006-02-15 04:44:00.000 |
|            6 | Argentina      | 2006-02-15 04:44:00.000 |
|            7 | Armenia        | 2006-02-15 04:44:00.000 |
|            8 | Australia      | 2006-02-15 04:44:00.000 |
|            9 | Austria        | 2006-02-15 04:44:00.000 |
|           10 | Azerbaijan     | 2006-02-15 04:44:00.000 |


Table: sakila customer
|   customer_id |   store_id | first_name   | last_name   | email                                |   address_id | active   | create_date             | last_update             | Full_name          |
|--------------:|-----------:|:-------------|:------------|:-------------------------------------|-------------:|:---------|:------------------------|:------------------------|:-------------------|
|           272 |          1 | KAY          | CALDWELL    | KAY.CALDWELL@sakilacustomer.org      |          277 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 | CALDWELL, KAY      |
|           274 |          1 | NAOMI        | JENNINGS    | NAOMI.JENNINGS@sakilacustomer.org    |          279 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 | JENNINGS, NAOMI    |
|           276 |          1 | BRANDY       | GRAVES      | BRANDY.GRAVES@sakilacustomer.org     |          281 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 | GRAVES, BRANDY     |
|           283 |          1 | FELICIA      | SUTTON      | FELICIA.SUTTON@sakilacustomer.org    |          288 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 | SUTTON, FELICIA    |
|           284 |          1 | SONIA        | GREGORY     | SONIA.GREGORY@sakilacustomer.org     |          289 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 | GREGORY, SONIA     |
|           285 |          1 | MIRIAM       | MCKINNEY    | MIRIAM.MCKINNEY@sakilacustomer.org   |          290 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 | MCKINNEY, MIRIAM   |
|           286 |          1 | VELMA        | LUCAS       | VELMA.LUCAS@sakilacustomer.org       |          291 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 | LUCAS, VELMA       |
|           288 |          1 | BOBBIE       | CRAIG       | BOBBIE.CRAIG@sakilacustomer.org      |          293 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 | CRAIG, BOBBIE      |
|           289 |          1 | VIOLET       | RODRIQUEZ   | VIOLET.RODRIQUEZ@sakilacustomer.org  |          294 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 | RODRIQUEZ, VIOLET  |
|           290 |          1 | KRISTINA     | CHAMBERS    | KRISTINA.CHAMBERS@sakilacustomer.org |          295 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 | CHAMBERS, KRISTINA |


Table: sakila customer_list
|   ID | name             | address                       |   zip code |        phone | city            | country        | notes   |   SID |
|-----:|:-----------------|:------------------------------|-----------:|-------------:|:----------------|:---------------|:--------|------:|
|  218 | VERA MCCOY       | 1168 Najafabad Parkway        |      40301 | 886649065861 | Kabul           | Afghanistan    | active  |     1 |
|  441 | MARIO CHEATHAM   | 1924 Shimonoseki Drive        |      52625 | 406784385440 | Batna           | Algeria        | active  |     1 |
|   69 | JUDY GRAY        | 1031 Daugavpils Parkway       |      59025 | 107137400143 | Bchar           | Algeria        | active  |     2 |
|  176 | JUNE CARROLL     | 757 Rustenburg Avenue         |      89668 | 506134035434 | Skikda          | Algeria        | active  |     1 |
|  320 | ANTHONY SCHWAB   | 1892 Nabereznyje Telny Lane   |      28396 | 478229987054 | Tafuna          | American Samoa | active  |     2 |
|  528 | CLAUDE HERZOG    | 486 Ondo Parkway              |      35202 | 105882218332 | Benguela        | Angola         | active  |     1 |
|  383 | MARTIN BALES     | 368 Hunuco Boulevard          |      17165 | 106439158941 | Namibe          | Angola         | active  |     1 |
|  381 | BOBBY BOUDREAU   | 1368 Maracabo Boulevard       |      32716 | 934352415130 | South Hill      | Anguilla       | active  |     2 |
|  359 | WILLIE MARKHAM   | 1623 Kingstown Drive          |      91299 | 296394569728 | Almirante Brown | Argentina      | active  |     2 |
|  560 | JORDAN ARCHULETA | 1229 Varanasi (Benares) Manor |      40195 | 817740355461 | Avellaneda      | Argentina      | active  |     1 |


Table: sakila film
|   film_id | title                | description                                                                                              |   release_year |   language_id | original_language_id   |   rental_duration |   rental_rate |   length |   replacement_cost | rating   | special_features                                       | last_update             |   newReplacement |
|----------:|:---------------------|:---------------------------------------------------------------------------------------------------------|---------------:|--------------:|:-----------------------|------------------:|--------------:|---------:|-------------------:|:---------|:-------------------------------------------------------|:------------------------|-----------------:|
|        17 | ALONE TRIP           | A Fast-Paced Character Study of a Composer And a Dog who must Outgun a Boat in An Abandoned Fun House    |           2006 |             1 |                        |                 3 |          0.99 |       82 |              14.99 | R        | Trailers,Behind the Scenes                             | 2006-02-15 05:03:42.000 |            14.99 |
|        23 | ANACONDA CONFESSIONS | A Lacklusture Display of a Dentist And a Dentist who must Fight a Girl in Australia                      |           2006 |             1 |                        |                 3 |          0.99 |       92 |               9.99 | R        | Trailers,Deleted Scenes                                | 2006-02-15 05:03:42.000 |             9.99 |
|        26 | ANNIE IDENTITY       | A Amazing Panorama of a Pastry Chef And a Boat who must Escape a Woman in An Abandoned Amusement Park    |           2006 |             1 |                        |                 3 |          0.99 |       86 |              15.99 | G        | Commentaries,Deleted Scenes                            | 2006-02-15 05:03:42.000 |            15.99 |
|        82 | BLOOD ARGONAUTS      | A Boring Drama of a Explorer And a Man who must Kill a Lumberjack in A Manhattan Penthouse               |           2006 |             1 |                        |                 3 |          0.99 |       71 |              13.99 | G        | Trailers,Commentaries,Behind the Scenes                | 2006-02-15 05:03:42.000 |            13.99 |
|        90 | BOULEVARD MOB        | A Fateful Epistle of a Moose And a Monkey who must Confront a Lumberjack in Ancient China                |           2006 |             1 |                        |                 3 |          0.99 |       63 |              11.99 | R        | Trailers                                               | 2006-02-15 05:03:42.000 |            11.99 |
|       101 | BROTHERHOOD BLANKET  | A Fateful Character Study of a Butler And a Technical Writer who must Sink a Astronaut in Ancient Japan  |           2006 |             1 |                        |                 3 |          0.99 |       73 |              26.99 | R        | Behind the Scenes                                      | 2006-02-15 05:03:42.000 |            26.99 |
|       109 | BUTTERFLY CHOCOLAT   | A Fateful Story of a Girl And a Composer who must Conquer a Husband in A Shark Tank                      |           2006 |             1 |                        |                 3 |          0.99 |       89 |              17.99 | G        | Behind the Scenes                                      | 2006-02-15 05:03:42.000 |            17.99 |
|       111 | CADDYSHACK JEDI      | A Awe-Inspiring Epistle of a Woman And a Madman who must Fight a Robot in Soviet Georgia                 |           2006 |             1 |                        |                 3 |          0.99 |       52 |              17.99 | NC-17    | Commentaries,Deleted Scenes                            | 2006-02-15 05:03:42.000 |            17.99 |
|       114 | CAMELOT VACATION     | A Touching Character Study of a Woman And a Waitress who must Battle a Pastry Chef in A MySQL Convention |           2006 |             1 |                        |                 3 |          0.99 |       61 |              26.99 | NC-17    | Trailers,Commentaries,Deleted Scenes,Behind the Scenes | 2006-02-15 05:03:42.000 |            26.99 |
|       142 | CHICKEN HELLFIGHTERS | A Emotional Drama of a Dog And a Explorer who must Outrace a Technical Writer in Australia               |           2006 |             1 |                        |                 3 |          0.99 |      122 |              24.99 | PG       | Trailers,Commentaries,Deleted Scenes,Behind the Scenes | 2006-02-15 05:03:42.000 |            24.99 |


Table: sakila film_actor
|   actor_id |   film_id | last_update             |
|-----------:|----------:|:------------------------|
|          1 |         1 | 2006-02-15 05:05:03.000 |
|          1 |        23 | 2006-02-15 05:05:03.000 |
|          1 |        25 | 2006-02-15 05:05:03.000 |
|          1 |       106 | 2006-02-15 05:05:03.000 |
|          1 |       140 | 2006-02-15 05:05:03.000 |
|          1 |       166 | 2006-02-15 05:05:03.000 |
|          1 |       277 | 2006-02-15 05:05:03.000 |
|          1 |       361 | 2006-02-15 05:05:03.000 |
|          1 |       438 | 2006-02-15 05:05:03.000 |
|          1 |       499 | 2006-02-15 05:05:03.000 |


Table: sakila film_category
|   film_id |   category_id | last_update             |
|----------:|--------------:|:------------------------|
|        10 |            15 | 2006-02-15 05:07:09.000 |
|        27 |            15 | 2006-02-15 05:07:09.000 |
|        42 |            15 | 2006-02-15 05:07:09.000 |
|       102 |            15 | 2006-02-15 05:07:09.000 |
|       113 |            15 | 2006-02-15 05:07:09.000 |
|       120 |            15 | 2006-02-15 05:07:09.000 |
|       135 |            15 | 2006-02-15 05:07:09.000 |
|       176 |            15 | 2006-02-15 05:07:09.000 |
|       187 |            15 | 2006-02-15 05:07:09.000 |
|       197 |            15 | 2006-02-15 05:07:09.000 |


Table: sakila film_list
|   FID | title              | description                                                                                                            | category   |   price |   length | rating   | actors                                                                                    |
|------:|:-------------------|:-----------------------------------------------------------------------------------------------------------------------|:-----------|--------:|---------:|:---------|:------------------------------------------------------------------------------------------|
|    18 | ALTER VICTORY      | A Thoughtful Drama of a Composer And a Feminist who must Meet a Secret Agent in The Canadian Rockies                   | Animation  |    0.99 |       57 | PG-13    | REESE KILMER, JADA RYDER, ANGELA WITHERSPOON, OPRAH KILMER                                |
|    36 | ARGONAUTS TOWN     | A Emotional Epistle of a Forensic Psychologist And a Butler who must Challenge a Waitress in An Abandoned Mine Shaft   | Animation  |    0.99 |      127 | PG-13    | JULIA BARRYMORE, GARY PENN, GENE WILLIS, DAN STREEP, KEVIN GARLAND                        |
|    64 | BEETHOVEN EXORCIST | A Epic Display of a Pioneer And a Student who must Challenge a Butler in The Gulf of Mexico                            | Drama      |    0.99 |      151 | PG-13    | SANDRA PECK, WARREN JACKMAN, SCARLETT BENING, MINNIE KILMER, VIVIEN BASINGER, BELA WALKEN |
|    79 | BLADE POLISH       | A Thoughtful Character Study of a Frisbee And a Pastry Chef who must Fight a Dentist in The First Manned Space Station | Drama      |    0.99 |      114 | PG-13    | JENNIFER DAVIS, ALEC WAYNE, KEVIN GARLAND, RIVER DEAN, ANGELA WITHERSPOON                 |
|   108 | BUTCH PANTHER      | A Lacklusture Yarn of a Feminist And a Database Administrator who must Face a Hunter in New Orleans                    | New        |    0.99 |       67 | PG-13    | CUBA OLIVIER, CARMEN HUNT, GROUCHO DUNST                                                  |
|   130 | CELEBRITY HORN     | A Amazing Documentary of a Secret Agent And a Astronaut who must Vanquish a Hunter in A Shark Tank                     | Action     |    0.99 |      110 | PG-13    | DUSTIN TAUTOU, MATTHEW LEIGH, ANGELA WITHERSPOON, JAYNE SILVERSTONE                       |
|   155 | CLEOPATRA DEVIL    | A Fanciful Documentary of a Crocodile And a Technical Writer who must Fight a A Shark in A Baloon                      | New        |    0.99 |      150 | PG-13    | KARL BERRY, FRED COSTNER, EWAN GOODING, KIM ALLEN, FAY WOOD, WILLIAM HACKMAN, JOHN SUVARI |
|   157 | CLOCKWORK PARADISE | A Insightful Documentary of a Technical Writer And a Feminist who must Challenge a Cat in A Baloon                     | Children   |    0.99 |      143 | PG-13    | SPENCER PECK, SYLVESTER DERN, SALMA NOLTE, KEVIN GARLAND, LUCILLE DEE                     |
|   160 | CLUB GRAFFITI      | A Epic Tale of a Pioneer And a Hunter who must Escape a Girl in A U-Boat                                               | Animation  |    0.99 |       65 | PG-13    | TOM MCKELLEN, MORGAN WILLIAMS, LISA MONROE, DEBBIE AKROYD                                 |
|   163 | CLYDE THEORY       | A Beautiful Yarn of a Astronaut And a Frisbee who must Overcome a Explorer in A Jet Boat                               | New        |    0.99 |      139 | PG-13    | SISSY SOBIESKI, JOHNNY CAGE, GREG CHAPLIN, MERYL ALLEN                                    |


Table: sakila film_text
|   film_id | title            | description                                                                                                           |
|----------:|:-----------------|:----------------------------------------------------------------------------------------------------------------------|
|         1 | ACADEMY DINOSAUR | A Epic Drama of a Feminist And a Mad Scientist who must Battle a Teacher in The Canadian Rockies                      |
|         2 | ACE GOLDFINGER   | A Astounding Epistle of a Database Administrator And a Explorer who must Find a Car in Ancient China                  |
|         3 | ADAPTATION HOLES | A Astounding Reflection of a Lumberjack And a Car who must Sink a Lumberjack in A Baloon Factory                      |
|         4 | AFFAIR PREJUDICE | A Fanciful Documentary of a Frisbee And a Lumberjack who must Chase a Monkey in A Shark Tank                          |
|         5 | AFRICAN EGG      | A Fast-Paced Documentary of a Pastry Chef And a Dentist who must Pursue a Forensic Psychologist in The Gulf of Mexico |
|         6 | AGENT TRUMAN     | A Intrepid Panorama of a Robot And a Boy who must Escape a Sumo Wrestler in Ancient China                             |
|         7 | AIRPLANE SIERRA  | A Touching Saga of a Hunter And a Butler who must Discover a Butler in A Jet Boat                                     |
|         8 | AIRPORT POLLOCK  | A Epic Tale of a Moose And a Girl who must Confront a Monkey in Ancient India                                         |
|         9 | ALABAMA DEVIL    | A Thoughtful Panorama of a Database Administrator And a Mad Scientist who must Outgun a Mad Scientist in A Jet Boat   |
|        10 | ALADDIN CALENDAR | A Action-Packed Tale of a Man And a Lumberjack who must Reach a Feminist in Ancient China                             |


Table: sakila inventory
|   inventory_id |   film_id |   store_id | last_update             |
|---------------:|----------:|-----------:|:------------------------|
|              5 |         1 |          2 | 2006-02-15 05:09:17.000 |
|              6 |         1 |          2 | 2006-02-15 05:09:17.000 |
|              7 |         1 |          2 | 2006-02-15 05:09:17.000 |
|              8 |         1 |          2 | 2006-02-15 05:09:17.000 |
|              9 |         2 |          2 | 2006-02-15 05:09:17.000 |
|             10 |         2 |          2 | 2006-02-15 05:09:17.000 |
|             11 |         2 |          2 | 2006-02-15 05:09:17.000 |
|             12 |         3 |          2 | 2006-02-15 05:09:17.000 |
|             13 |         3 |          2 | 2006-02-15 05:09:17.000 |
|             14 |         3 |          2 | 2006-02-15 05:09:17.000 |


Table: sakila language
|   language_id | name     | last_update             |
|--------------:|:---------|:------------------------|
|             1 | English  | 2006-02-15 05:02:19.000 |
|             2 | Italian  | 2006-02-15 05:02:19.000 |
|             3 | Japanese | 2006-02-15 05:02:19.000 |
|             4 | Mandarin | 2006-02-15 05:02:19.000 |
|             5 | French   | 2006-02-15 05:02:19.000 |
|             6 | German   | 2006-02-15 05:02:19.000 |


Table: sakila nicer_but_slower_film_list
|   FID | title              | description                                                                                                            | category   |   price |   length | rating   | actors                                                                                    |
|------:|:-------------------|:-----------------------------------------------------------------------------------------------------------------------|:-----------|--------:|---------:|:---------|:------------------------------------------------------------------------------------------|
|    18 | ALTER VICTORY      | A Thoughtful Drama of a Composer And a Feminist who must Meet a Secret Agent in The Canadian Rockies                   | Animation  |    0.99 |       57 | PG-13    | Reese Kilmer, Jada Ryder, Angela Witherspoon, Oprah Kilmer                                |
|    36 | ARGONAUTS TOWN     | A Emotional Epistle of a Forensic Psychologist And a Butler who must Challenge a Waitress in An Abandoned Mine Shaft   | Animation  |    0.99 |      127 | PG-13    | Julia Barrymore, Gary Penn, Gene Willis, Dan Streep, Kevin Garland                        |
|    64 | BEETHOVEN EXORCIST | A Epic Display of a Pioneer And a Student who must Challenge a Butler in The Gulf of Mexico                            | Drama      |    0.99 |      151 | PG-13    | Sandra Peck, Warren Jackman, Scarlett Bening, Minnie Kilmer, Vivien Basinger, Bela Walken |
|    79 | BLADE POLISH       | A Thoughtful Character Study of a Frisbee And a Pastry Chef who must Fight a Dentist in The First Manned Space Station | Drama      |    0.99 |      114 | PG-13    | Jennifer Davis, Alec Wayne, Kevin Garland, River Dean, Angela Witherspoon                 |
|   108 | BUTCH PANTHER      | A Lacklusture Yarn of a Feminist And a Database Administrator who must Face a Hunter in New Orleans                    | New        |    0.99 |       67 | PG-13    | Cuba Olivier, Carmen Hunt, Groucho Dunst                                                  |
|   130 | CELEBRITY HORN     | A Amazing Documentary of a Secret Agent And a Astronaut who must Vanquish a Hunter in A Shark Tank                     | Action     |    0.99 |      110 | PG-13    | Dustin Tautou, Matthew Leigh, Angela Witherspoon, Jayne Silverstone                       |
|   155 | CLEOPATRA DEVIL    | A Fanciful Documentary of a Crocodile And a Technical Writer who must Fight a A Shark in A Baloon                      | New        |    0.99 |      150 | PG-13    | Karl Berry, Fred Costner, Ewan Gooding, Kim Allen, Fay Wood, William Hackman, John Suvari |
|   157 | CLOCKWORK PARADISE | A Insightful Documentary of a Technical Writer And a Feminist who must Challenge a Cat in A Baloon                     | Children   |    0.99 |      143 | PG-13    | Spencer Peck, Sylvester Dern, Salma Nolte, Kevin Garland, Lucille Dee                     |
|   160 | CLUB GRAFFITI      | A Epic Tale of a Pioneer And a Hunter who must Escape a Girl in A U-Boat                                               | Animation  |    0.99 |       65 | PG-13    | Tom Mckellen, Morgan Williams, Lisa Monroe, Debbie Akroyd                                 |
|   163 | CLYDE THEORY       | A Beautiful Yarn of a Astronaut And a Frisbee who must Overcome a Explorer in A Jet Boat                               | New        |    0.99 |      139 | PG-13    | Sissy Sobieski, Johnny Cage, Greg Chaplin, Meryl Allen                                    |


Table: sakila payment
|   payment_id |   customer_id |   staff_id |   rental_id |   amount | payment_date            | last_update             |
|-------------:|--------------:|-----------:|------------:|---------:|:------------------------|:------------------------|
|           17 |             1 |          2 |        8033 |     4.99 | 2005-07-28 16:18:23.000 | 2006-02-15 22:12:30.000 |
|           22 |             1 |          2 |       10437 |     4.99 | 2005-08-01 08:51:04.000 | 2006-02-15 22:12:30.000 |
|           25 |             1 |          2 |       11824 |     4.99 | 2005-08-17 12:37:54.000 | 2006-02-15 22:12:30.000 |
|           37 |             2 |          2 |        7346 |     4.99 | 2005-07-27 14:30:42.000 | 2006-02-15 22:12:30.000 |
|           58 |             2 |          2 |       15145 |     4.99 | 2005-08-22 13:53:04.000 | 2006-02-15 22:12:30.000 |
|           59 |             2 |          2 |       15907 |     4.99 | 2005-08-23 17:39:35.000 | 2006-02-15 22:12:30.000 |
|           73 |             3 |          2 |        8086 |     4.99 | 2005-07-28 18:17:14.000 | 2006-02-15 22:12:30.000 |
|           78 |             3 |          2 |        9816 |     4.99 | 2005-07-31 11:32:58.000 | 2006-02-15 22:12:30.000 |
|           80 |             3 |          2 |       12556 |     4.99 | 2005-08-18 14:49:55.000 | 2006-02-15 22:12:30.000 |
|           99 |             4 |          2 |       11529 |     4.99 | 2005-08-17 00:28:01.000 | 2006-02-15 22:12:30.000 |


Table: sakila rental
|   rental_id | rental_date             |   inventory_id |   customer_id | return_date   |   staff_id | last_update             |
|------------:|:------------------------|---------------:|--------------:|:--------------|-----------:|:------------------------|
|       11496 | 2006-02-14 15:16:03.000 |           2047 |           155 |               |          1 | 2006-02-15 21:30:53.000 |
|       11541 | 2006-02-14 15:16:03.000 |           2026 |           335 |               |          1 | 2006-02-15 21:30:53.000 |
|       11563 | 2006-02-14 15:16:03.000 |           1545 |            83 |               |          1 | 2006-02-15 21:30:53.000 |
|       11593 | 2006-02-14 15:16:03.000 |            817 |            99 |               |          1 | 2006-02-15 21:30:53.000 |
|       11709 | 2006-02-14 15:16:03.000 |           1720 |           330 |               |          1 | 2006-02-15 21:30:53.000 |
|       11782 | 2006-02-14 15:16:03.000 |           4098 |           354 |               |          1 | 2006-02-15 21:30:53.000 |
|       11847 | 2006-02-14 15:16:03.000 |           1784 |           337 |               |          1 | 2006-02-15 21:30:53.000 |
|       11848 | 2006-02-14 15:16:03.000 |           3680 |           152 |               |          1 | 2006-02-15 21:30:53.000 |
|       11909 | 2006-02-14 15:16:03.000 |            871 |           474 |               |          1 | 2006-02-15 21:30:53.000 |
|       11995 | 2006-02-14 15:16:03.000 |           3953 |            69 |               |          1 | 2006-02-15 21:30:53.000 |


Table: sakila sales_by_film_category
| category   |   total_sales |
|:-----------|--------------:|
| Sports     |       5314.21 |
| Sci-Fi     |       4756.98 |
| Animation  |       4656.3  |
| Drama      |       4587.39 |
| Comedy     |       4383.58 |
| Action     |       4375.85 |
| New        |       4351.62 |
| Games      |       4281.33 |
| Foreign    |       4270.67 |
| Family     |       4226.07 |


Table: sakila sales_by_store
| store               | manager      |   total_sales |
|:--------------------|:-------------|--------------:|
| Woodridge,Australia | Jon Stephens |       33726.8 |
| Lethbridge,Canada   | Mike Hillyer |       33679.8 |


Table: sakila staff
|   staff_id | first_name   | last_name   |   address_id | email                        |   store_id | active   | username   | password                                 | last_update             |
|-----------:|:-------------|:------------|-------------:|:-----------------------------|-----------:|:---------|:-----------|:-----------------------------------------|:------------------------|
|          1 | Mike         | Hillyer     |            3 | Mike.Hillyer@sakilastaff.com |          1 | True     | Mike       | 8cb2237d0679ca88db6464eac60da96345513964 | 2006-02-15 03:57:16.000 |
|          2 | Jon          | Stephens    |            4 | Jon.Stephens@sakilastaff.com |          2 | True     | Jon        |                                          | 2006-02-15 03:57:16.000 |


Table: sakila staff_list
|   ID | name         | address              | zip code   |       phone | city       | country   |   SID |
|-----:|:-------------|:---------------------|:-----------|------------:|:-----------|:----------|------:|
|    1 | Mike Hillyer | 23 Workhaven Lane    |            | 14033335568 | Lethbridge | Canada    |     1 |
|    2 | Jon Stephens | 1411 Lillydale Drive |            |  6172235589 | Woodridge  | Australia |     2 |


Table: sakila store
|   store_id |   manager_staff_id |   address_id | last_update             |
|-----------:|-------------------:|-------------:|:------------------------|
|          1 |                  1 |            1 | 2006-02-15 04:57:12.000 |
|          2 |                  2 |            2 | 2006-02-15 04:57:12.000 |

 


tables: name: sakila actor
data: sakila actor.csv
name: sakila actor_info
data: sakila actor_info.csv
name: sakila address
data: sakila address.csv
name: sakila category
data: sakila category.csv
name: sakila city
data: sakila city.csv
name: sakila country
data: sakila country.csv
name: sakila customer
data: sakila customer.csv
name: sakila customer_list
data: sakila customer_list.csv
name: sakila film
data: sakila film.csv
name: sakila film_actor
data: sakila film_actor.csv
name: sakila film_category
data: sakila film_category.csv
name: sakila film_list
data: sakila film_list.csv
name: sakila film_text
data: sakila film_text.csv
name: sakila inventory
data: sakila inventory.csv
name: sakila language
data: sakila language.csv
name: sakila nicer_but_slower_film_list
data: sakila nicer_but_slower_film_list.csv
name: sakila payment
data: sakila payment.csv
name: sakila rental
data: sakila rental.csv
name: sakila sales_by_film_category
data: sakila sales_by_film_category.csv
name: sakila sales_by_store
data: sakila sales_by_store.csv
name: sakila staff
data: sakila staff.csv
name: sakila staff_list
data: sakila staff_list.csv
name: sakila store
data: sakila store.csv
label: sakila film_actor
actor_id
sakila actor
actor_id
sakila address
city_id
sakila city
city_id
sakila customer
address_id
sakila address
address_id
sakila staff
address_id
sakila address
address_id
sakila store
address_id
sakila address
address_id
sakila film_category
category_id
sakila category
category_id
sakila city
country_id
sakila country
country_id
sakila rental
customer_id
sakila customer
customer_id
sakila film_actor
film_id
sakila film
film_id
sakila film_category
film_id
sakila film
film_id
sakila inventory
film_id
sakila film
film_id
sakila film
language_id
sakila language
language_id
sakila rental
inventory_id
sakila inventory
inventory_id
sakila payment
rental_id
sakila rental
rental_id
sakila actor_info
actor_id
sakila actor
actor_id
sakila staff_list
ID
sakila customer_list
ID
sakila customer_list
address
sakila address
address
sakila film_list
title
sakila film
title
sakila nicer_but_slower_film_list
title
sakila film
title
sakila film_text
title
sakila film
title
sakila film_list
category
sakila sales_by_film_category
category
output: {
    "joins": [
        {
            "from_table": "sakila film_actor",
            "from_column": "actor_id",
            "to_table": "sakila actor",
            "to_column": "actor_id"
        },
        {
            "from_table": "sakila address",
            "from_column": "city_id",
            "to_table": "sakila city",
            "to_column": "city_id"
        },
        {
            "from_table": "sakila customer",
            "from_column": "address_id",
            "to_table": "sakila address",
            "to_column": "address_id"
        },
        {
            "from_table": "sakila staff",
            "from_column": "address_id",
            "to_table": "sakila address",
            "to_column": "address_id"
        },
        {
            "from_table": "sakila store",
            "from_column": "address_id",
            "to_table": "sakila address",
            "to_column": "address_id"
        },
        {
            "from_table": "sakila film_category",
            "from_column": "category_id",
            "to_table": "sakila category",
            "to_column": "category_id"
        },
        {
            "from_table": "sakila city",
            "from_column": "country_id",
            "to_table": "sakila country",
            "to_column": "country_id"
        },
        {
            "from_table": "sakila rental",
            "from_column": "customer_id",
            "to_table": "sakila customer",
            "to_column": "customer_id"
        },
        {
            "from_table": "sakila film_actor",
            "from_column": "film_id",
            "to_table": "sakila film",
            "to_column": "film_id"
        },
        {
            "from_table": "sakila film_category",
            "from_column": "film_id",
            "to_table": "sakila film",
            "to_column": "film_id"
        },
        {
            "from_table": "sakila inventory",
            "from_column": "film_id",
            "to_table": "sakila film",
            "to_column": "film_id"
        },
        {
            "from_table": "sakila film",
            "from_column": "language_id",
            "to_table": "sakila language",
            "to_column": "language_id"
        },
        {
            "from_table": "sakila rental",
            "from_column": "inventory_id",
            "to_table": "sakila inventory",
            "to_column": "inventory_id"
        },
        {
            "from_table": "sakila payment",
            "from_column": "rental_id",
            "to_table": "sakila rental",
            "to_column": "rental_id"
        },
        {
            "from_table": "sakila actor_info",
            "from_column": "actor_id",
            "to_table": "sakila actor",
            "to_column": "actor_id"
        },
        {
            "from_table": "sakila staff_list",
            "from_column": "ID",
            "to_table": "sakila customer_list",
            "to_column": "ID"
        },
        {
            "from_table": "sakila customer_list",
            "from_column": "address",
            "to_table": "sakila address",
            "to_column": "address"
        },
        {
            "from_table": "sakila film_list",
            "from_column": "title",
            "to_table": "sakila film",
            "to_column": "title"
        },
        {
            "from_table": "sakila nicer_but_slower_film_list",
            "from_column": "title",
            "to_table": "sakila film",
            "to_column": "title"
        },
        {
            "from_table": "sakila film_text",
            "from_column": "title",
            "to_table": "sakila film",
            "to_column": "title"
        },
        {
            "from_table": "sakila film_list",
            "from_column": "category",
            "to_table": "sakila sales_by_film_category",
            "to_column": "category"
        }
    ]
}