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   | last_update             |
|-------------:|:--------------------------------|:-----------|:-----------|----------:|:--------------|:--------|:------------------------|
|            1 | 47 MySakila Drive               |            |            |       300 |               |         | 2006-02-15 04:45:30.000 |
|            2 | 28 MySQL Boulevard              |            |            |       576 |               |         | 2006-02-15 04:45:30.000 |
|            3 | 23 Workhaven Lane               |            |            |       300 |               |         | 2006-02-15 04:45:30.000 |
|            4 | 1411 Lillydale Drive            |            |            |       576 |               |         | 2006-02-15 04:45:30.000 |
|            5 | 1913 Hanoi Way                  |            |            |       463 | 35200         |         | 2006-02-15 04:45:30.000 |
|            6 | 1121 Loja Avenue                |            |            |       449 | 17886         |         | 2006-02-15 04:45:30.000 |
|            7 | 692 Joliet Street               |            |            |        38 | 83579         |         | 2006-02-15 04:45:30.000 |
|            8 | 1566 Inegl Manor                |            |            |       349 | 53561         |         | 2006-02-15 04:45:30.000 |
|            9 | 53 Idfu Parkway                 |            |            |       361 | 42399         |         | 2006-02-15 04:45:30.000 |
|           10 | 1795 Santiago de Compostela Way |            |            |       295 | 18743         |         | 2006-02-15 04:45:30.000 |


Table: sakila category
| category_id   | name        | last_update             |
|:--------------|:------------|:------------------------|
| True          | Action      | 2006-02-15 04:46:27.000 |
| True          | Animation   | 2006-02-15 04:46:27.000 |
| True          | Children    | 2006-02-15 04:46:27.000 |
| True          | Classics    | 2006-02-15 04:46:27.000 |
| True          | Comedy      | 2006-02-15 04:46:27.000 |
| True          | Documentary | 2006-02-15 04:46:27.000 |
| True          | Drama       | 2006-02-15 04:46:27.000 |
| True          | Family      | 2006-02-15 04:46:27.000 |
| True          | Foreign     | 2006-02-15 04:46:27.000 |
| True          | 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             |
|--------------:|:-----------|:-------------|:------------|:----------------------------------|-------------:|:---------|:------------------------|:------------------------|
|           272 | True       | KAY          | CALDWELL    | KAY.CALDWELL@sakilacustomer.org   |          277 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 |
|           273 | True       | PRISCILLA    | LOWE        | PRISCILLA.LOWE@sakilacustomer.org |          278 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 |
|           274 | True       | NAOMI        | JENNINGS    | NAOMI.JENNINGS@sakilacustomer.org |          279 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 |
|           275 | True       | CAROLE       | BARNETT     | CAROLE.BARNETT@sakilacustomer.org |          280 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 |
|           276 | True       | BRANDY       | GRAVES      | BRANDY.GRAVES@sakilacustomer.org  |          281 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 |
|           277 | True       | OLGA         | JIMENEZ     | OLGA.JIMENEZ@sakilacustomer.org   |          282 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 |
|           278 | True       | BILLIE       | HORTON      | BILLIE.HORTON@sakilacustomer.org  |          283 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 |
|           279 | True       | DIANNE       | SHELTON     | DIANNE.SHELTON@sakilacustomer.org |          284 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 |
|           280 | True       | TRACEY       | BARRETT     | TRACEY.BARRETT@sakilacustomer.org |          285 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 |
|           281 | True       | LEONA        | OBRIEN      | LEONA.OBRIEN@sakilacustomer.org   |          286 | True     | 2006-02-14 22:04:37.000 | 2006-02-15 04:57:20.000 |


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


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             |
|----------:|:-------------------|:-----------------------------------------------------------------------------------------------------------------------|---------------:|:--------------|:-----------------------|:------------------|--------------:|---------:|-------------------:|:---------|:-------------------------------------------------------|:------------------------|
|        18 | ALTER VICTORY      | A Thoughtful Drama of a Composer And a Feminist who must Meet a Secret Agent in The Canadian Rockies                   |           2006 | True          |                        | True              |          0.99 |       57 |              27.99 | PG-13    | Trailers,Behind the Scenes                             | 2006-02-15 05:03:42.000 |
|        36 | ARGONAUTS TOWN     | A Emotional Epistle of a Forensic Psychologist And a Butler who must Challenge a Waitress in An Abandoned Mine Shaft   |           2006 | True          |                        | True              |          0.99 |      127 |              12.99 | PG-13    | Trailers,Commentaries                                  | 2006-02-15 05:03:42.000 |
|        64 | BEETHOVEN EXORCIST | A Epic Display of a Pioneer And a Student who must Challenge a Butler in The Gulf of Mexico                            |           2006 | True          |                        | True              |          0.99 |      151 |              26.99 | PG-13    | Commentaries,Behind the Scenes                         | 2006-02-15 05:03:42.000 |
|        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 |           2006 | True          |                        | True              |          0.99 |      114 |              10.99 | PG-13    | Trailers,Behind the Scenes                             | 2006-02-15 05:03:42.000 |
|       108 | BUTCH PANTHER      | A Lacklusture Yarn of a Feminist And a Database Administrator who must Face a Hunter in New Orleans                    |           2006 | True          |                        | True              |          0.99 |       67 |              19.99 | PG-13    | Trailers,Commentaries,Deleted Scenes                   | 2006-02-15 05:03:42.000 |
|       130 | CELEBRITY HORN     | A Amazing Documentary of a Secret Agent And a Astronaut who must Vanquish a Hunter in A Shark Tank                     |           2006 | True          |                        | True              |          0.99 |      110 |              24.99 | PG-13    | Deleted Scenes,Behind the Scenes                       | 2006-02-15 05:03:42.000 |
|       155 | CLEOPATRA DEVIL    | A Fanciful Documentary of a Crocodile And a Technical Writer who must Fight a A Shark in A Baloon                      |           2006 | True          |                        | True              |          0.99 |      150 |              26.99 | PG-13    | Trailers,Deleted Scenes,Behind the Scenes              | 2006-02-15 05:03:42.000 |
|       157 | CLOCKWORK PARADISE | A Insightful Documentary of a Technical Writer And a Feminist who must Challenge a Cat in A Baloon                     |           2006 | True          |                        | True              |          0.99 |      143 |              29.99 | PG-13    | Trailers,Commentaries,Deleted Scenes,Behind the Scenes | 2006-02-15 05:03:42.000 |
|       160 | CLUB GRAFFITI      | A Epic Tale of a Pioneer And a Hunter who must Escape a Girl in A U-Boat                                               |           2006 | True          |                        | True              |          0.99 |       65 |              12.99 | PG-13    | Trailers,Deleted Scenes                                | 2006-02-15 05:03:42.000 |
|       163 | CLYDE THEORY       | A Beautiful Yarn of a Astronaut And a Frisbee who must Overcome a Explorer in A Jet Boat                               |           2006 | True          |                        | True              |          0.99 |      139 |              29.99 | PG-13    | Commentaries,Deleted Scenes,Behind the Scenes          | 2006-02-15 05:03:42.000 |


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             |
|----------:|:--------------|:------------------------|
|         1 | True          | 2006-02-15 05:07:09.000 |
|         2 | True          | 2006-02-15 05:07:09.000 |
|         3 | True          | 2006-02-15 05:07:09.000 |
|         4 | True          | 2006-02-15 05:07:09.000 |
|         5 | True          | 2006-02-15 05:07:09.000 |
|         6 | True          | 2006-02-15 05:07:09.000 |
|         7 | True          | 2006-02-15 05:07:09.000 |
|         8 | True          | 2006-02-15 05:07:09.000 |
|         9 | True          | 2006-02-15 05:07:09.000 |
|        10 | True          | 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             |
|---------------:|----------:|:-----------|:------------------------|
|              1 |         1 | True       | 2006-02-15 05:09:17.000 |
|              2 |         1 | True       | 2006-02-15 05:09:17.000 |
|              3 |         1 | True       | 2006-02-15 05:09:17.000 |
|              4 |         1 | True       | 2006-02-15 05:09:17.000 |
|              5 |         1 | True       | 2006-02-15 05:09:17.000 |
|              6 |         1 | True       | 2006-02-15 05:09:17.000 |
|              7 |         1 | True       | 2006-02-15 05:09:17.000 |
|              8 |         1 | True       | 2006-02-15 05:09:17.000 |
|              9 |         2 | True       | 2006-02-15 05:09:17.000 |
|             10 |         2 | True       | 2006-02-15 05:09:17.000 |


Table: sakila language
| language_id   | name     | last_update             |
|:--------------|:---------|:------------------------|
| True          | English  | 2006-02-15 05:02:19.000 |
| True          | Italian  | 2006-02-15 05:02:19.000 |
| True          | Japanese | 2006-02-15 05:02:19.000 |
| True          | Mandarin | 2006-02-15 05:02:19.000 |
| True          | French   | 2006-02-15 05:02:19.000 |
| True          | 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 | 2016-07-28 16:18:23.000 | 2017-02-15 22:12:30.000 |
|           22 |             1 |          2 |       10437 |     4.99 | 2016-08-01 08:51:04.000 | 2017-02-15 22:12:30.000 |
|           25 |             1 |          2 |       11824 |     4.99 | 2016-08-17 12:37:54.000 | 2017-02-15 22:12:30.000 |
|           37 |             2 |          2 |        7346 |     4.99 | 2016-07-27 14:30:42.000 | 2017-02-15 22:12:30.000 |
|           58 |             2 |          2 |       15145 |     4.99 | 2016-08-22 13:53:04.000 | 2017-02-15 22:12:30.000 |
|           59 |             2 |          2 |       15907 |     4.99 | 2016-08-23 17:39:35.000 | 2017-02-15 22:12:30.000 |
|           73 |             3 |          2 |        8086 |     4.99 | 2016-07-28 18:17:14.000 | 2017-02-15 22:12:30.000 |
|           78 |             3 |          2 |        9816 |     4.99 | 2016-07-31 11:32:58.000 | 2017-02-15 22:12:30.000 |
|           80 |             3 |          2 |       12556 |     4.99 | 2016-08-18 14:49:55.000 | 2017-02-15 22:12:30.000 |
|           99 |             4 |          2 |       11529 |     4.99 | 2016-08-17 00:28:01.000 | 2017-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 |               | True       | 2006-02-15 21:30:53.000 |
|       11541 | 2006-02-14 15:16:03.000 |           2026 |           335 |               | True       | 2006-02-15 21:30:53.000 |
|       11563 | 2006-02-14 15:16:03.000 |           1545 |            83 |               | True       | 2006-02-15 21:30:53.000 |
|       11577 | 2006-02-14 15:16:03.000 |           4106 |           219 |               | True       | 2006-02-15 21:30:53.000 |
|       11593 | 2006-02-14 15:16:03.000 |            817 |            99 |               | True       | 2006-02-15 21:30:53.000 |
|       11611 | 2006-02-14 15:16:03.000 |           1857 |           192 |               | True       | 2006-02-15 21:30:53.000 |
|       11646 | 2006-02-14 15:16:03.000 |            478 |            11 |               | True       | 2006-02-15 21:30:53.000 |
|       11652 | 2006-02-14 15:16:03.000 |           1622 |           597 |               | True       | 2006-02-15 21:30:53.000 |
|       11657 | 2006-02-14 15:16:03.000 |           3043 |            53 |               | True       | 2006-02-15 21:30:53.000 |
|       11672 | 2006-02-14 15:16:03.000 |           3947 |           521 |               | True       | 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      |       4596.39 |
| Comedy     |       4383.58 |
| Action     |       4375.85 |
| New        |       4351.62 |
| Games      |       4281.33 |
| Foreign    |       4275.67 |
| Family     |       4226.07 |


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


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


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


Table: sakila store
| store_id   | manager_staff_id   |   address_id | last_update             |
|:-----------|:-------------------|-------------:|:------------------------|
| True       | True               |            1 | 2006-02-15 04:57:12.000 |
| True       | True               |            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 city
country_id
sakila country
country_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 rental
inventory_id
sakila inventory
inventory_id
sakila actor_info
actor_id
sakila actor
actor_id
sakila customer_list
address
sakila address
address
sakila staff_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
sakila payment
customer_id
sakila customer
customer_id
sakila payment
rental_id
sakila rental
rental_id
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 city",
            "from_column": "country_id",
            "to_table": "sakila country",
            "to_column": "country_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 rental",
            "from_column": "inventory_id",
            "to_table": "sakila inventory",
            "to_column": "inventory_id"
        },
        {
            "from_table": "sakila actor_info",
            "from_column": "actor_id",
            "to_table": "sakila actor",
            "to_column": "actor_id"
        },
        {
            "from_table": "sakila customer_list",
            "from_column": "address",
            "to_table": "sakila address",
            "to_column": "address"
        },
        {
            "from_table": "sakila staff_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"
        },
        {
            "from_table": "sakila payment",
            "from_column": "customer_id",
            "to_table": "sakila customer",
            "to_column": "customer_id"
        },
        {
            "from_table": "sakila payment",
            "from_column": "rental_id",
            "to_table": "sakila rental",
            "to_column": "rental_id"
        }
    ]
}