GraphGists

注意:我们对初始化块进行了分支,因为图非常大,并且我们连续收到 http 500 错误。现在我们有 1k 个查询!它很慢,大约需要十分钟。如果您不想等待,可以 下载 它并在本地进行测试。

NBA 球鞋

动机

如今,每个人都同意嘻哈文化和篮球有着深厚的关系。从 RUN DMC 的“My Adidas”,到 1985 年迈克尔·乔丹的首次亮相,直到现在,运动鞋的重要性越来越大。普遍认为它们是身份地位的象征。

我们的主要目标是研究不同品牌的运动鞋对 NBA 篮球联赛的影响。对这个话题进行概括很容易,但实际上问题极其复杂。我们创建了一个图,用于可视化球员与其所穿鞋之间的关系。此外,它还提供了有关球队、联盟和赛区的信息。

数据模型

Cp4Qsq6

让我们首先尝试更多地了解该图。我们使用这些标签来表示

  • 球员:篮球运动员。此外,一名球员可以是

    • 新秀:一年级球员。

    • 全明星:非常优秀的球员。

  • 球队:在 NBA 比赛的职业篮球队。

  • 型号:运动鞋型号。

  • 品牌:生产运动鞋的公司。

  • 赛区:NBA 的六个赛区之一。

  • 联盟:东部或西部,某个赛区所属的联盟。

入门

此查询创建了图!

create (_0:`Conference` {`name`:"East"})
 create (_1:`Conference` {`name`:"West"})
 create (_2:`Division` {`name`:"Atlantic"})
 create (_3:`Division` {`name`:"Southeast"})
 create (_4:`Division` {`name`:"Central"})
 create (_5:`Division` {`name`:"Northwest"})
 create (_6:`Division` {`name`:"Southwest"})
 create (_7:`Division` {`name`:"Pacific"})
 create (_34152:`Team` {`abbreviation`:"ATL", `city`:"Atlanta", `full_name`:"Atlanta Hawks"})
 create (_34153:`Player` {`age`:31, `birthplace`:"Skopje, Macedonia", `first_name`:"Pero", `height_formatted`:"6'11\"", `last_name`:"Antic", `shoe_size`:19.5})
 create (_34154:`Player` {`age`:28, `birthplace`:"Tepic, Mexico", `first_name`:"Gustavo", `height_formatted`:"6'10\"", `last_name`:"Ayon", `shoe_size`:17})
 create (_34155:`Player` {`age`:34, `birthplace`:"Peekskill, New York, USA", `first_name`:"Elton", `height_formatted`:"6'8\"", `last_name`:"Brand", `shoe_size`:17})
 create (_34156:`Player` {`age`:27, `birthplace`:"Birmingham, Alabama, USA", `first_name`:"DeMarre", `height_formatted`:"6'8\"", `last_name`:"Carroll", `shoe_size`:14})
 create (_34157:`Player` {`age`:22, `birthplace`:"Oakland, California, USA", `first_name`:"Jared", `height_formatted`:"6'4\"", `last_name`:"Cunningham", `shoe_size`:13})
 create (_34158:`Player` {`age`:27, `birthplace`:"Puerto Plata, Dominican Republic", `first_name`:"Al", `height_formatted`:"6'10\"", `last_name`:"Horford", `shoe_size`:17})
 create (_34159:`Player` {`age`:22, `birthplace`:"Hendersonville, Tennessee, USA", `first_name`:"John", `height_formatted`:"6'4\"", `last_name`:"Jenkins", `shoe_size`:15})
 create (_34160:`Player` {`age`:32, `birthplace`:"Lakewood, California, USA", `first_name`:"Kyle", `height_formatted`:"6'7\"", `last_name`:"Korver", `shoe_size`:14})
 create (_34161:`Player` {`age`:23, `birthplace`:"Lexington, Kentucky, USA", `first_name`:"Shelvin", `height_formatted`:"6'3\"", `last_name`:"Mack", `shoe_size`:14})
 create (_34162:`Player` {`age`:29, `birthplace`:"Crockett, Texas, USA", `first_name`:"Cartier", `height_formatted`:"6'7\"", `last_name`:"Martin", `shoe_size`:13.5})
 create (_34163:`Player` {`age`:28, `birthplace`:"Monroe, Louisiana, USA", `first_name`:"Paul", `height_formatted`:"6'8\"", `last_name`:"Millsap", `shoe_size`:16})
 create (_34164:`Player` {`age`:25, `birthplace`:"Chesapeake, Virginia, USA", `first_name`:"Mike", `height_formatted`:"6'8\"", `last_name`:"Scott", `shoe_size`:16})
 create (_34165:`Player` {`age`:25, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"Jeff", `height_formatted`:"6'2\"", `last_name`:"Teague", `shoe_size`:12})
 create (_34166:`Player` {`age`:27, `birthplace`:"Lithonia, Georgia, USA", `first_name`:"Louis", `height_formatted`:"6'2\"", `last_name`:"Williams", `shoe_size`:12})
 create (_34167:`Team` {`abbreviation`:"BOS", `city`:"Boston", `full_name`:"Boston Celtics"})
 create (_34168:`Player` {`age`:28, `birthplace`:"Baton Rouge, Louisiana, USA", `first_name`:"Brandon", `height_formatted`:"6'8\"", `last_name`:"Bass", `shoe_size`:15.5})
 create (_34169:`Player` {`age`:33, `birthplace`:"Alexandria, Virginia, USA", `first_name`:"Keith", `height_formatted`:"6'5\"", `last_name`:"Bogans", `shoe_size`:13.5})
 create (_34170:`Player` {`age`:23, `birthplace`:"Tacoma, Washington, USA", `first_name`:"Avery", `height_formatted`:"6'2\"", `last_name`:"Bradley", `shoe_size`:13})
 create (_34171:`Player` {`age`:24, `birthplace`:"Stone Mountain, Georgia, USA", `first_name`:"MarShon", `height_formatted`:"6'5\"", `last_name`:"Brooks", `shoe_size`:12})
 create (_34172:`Player` {`age`:25, `birthplace`:"Detroit, Michigan, USA", `first_name`:"Jordan", `height_formatted`:"6'4\"", `last_name`:"Crawford", `shoe_size`:12.5})
 create (_34173:`Player` {`age`:25, `birthplace`:"Porto Alegre, Brazil", `first_name`:"Vitor", `height_formatted`:"6'11\"", `last_name`:"Faverani", `shoe_size`:16.5})
 create (_34174:`Player` {`age`:27, `birthplace`:"Cheverly, Maryland, USA", `first_name`:"Jeff", `height_formatted`:"6'9\"", `last_name`:"Green", `shoe_size`:15})
 create (_34175:`Player` {`age`:28, `birthplace`:"Minneapolis, Minnesota, USA", `first_name`:"Kris", `height_formatted`:"6'9\"", `last_name`:"Humphries", `shoe_size`:14.5})
 create (_34176:`Player` {`age`:28, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"Courtney", `height_formatted`:"6'5\"", `last_name`:"Lee", `shoe_size`:13})
 create (_34177:`Player`:`Rookie` {`age`:22, `birthplace`:"Toronto, Canada", `first_name`:"Kelly", `height_formatted`:"7'0\"", `last_name`:"Olynyk", `shoe_size`:17})
 create (_34178:`Player` {`age`:22, `birthplace`:"Dallas, Texas, USA", `first_name`:"Phil", `height_formatted`:"5'11\"", `last_name`:"Pressey", `shoe_size`:11})
 create (_34179:`Player`:`AllStar` {`age`:27, `birthplace`:"Louisville, Kentucky, USA", `first_name`:"Rajon", `height_formatted`:"6'1\"", `last_name`:"Rondo", `shoe_size`:13})
 create (_34180:`Player` {`age`:21, `birthplace`:"Columbus, Ohio, USA", `first_name`:"Jared", `height_formatted`:"6'9\"", `last_name`:"Sullinger", `shoe_size`:18})
 create (_34181:`Player` {`age`:31, `birthplace`:"Sylacauga, Alabama, USA", `first_name`:"Gerald", `height_formatted`:"6'7\"", `last_name`:"Wallace", `shoe_size`:14})
 create (_34182:`Team` {`abbreviation`:"BKN", `city`:"Brooklyn", `full_name`:"Brooklyn Nets"})
 create (_34183:`Player` {`age`:31, `birthplace`:"Minneapolis, Minnesota, USA", `first_name`:"Alan", `height_formatted`:"6'6\"", `last_name`:"Anderson", `shoe_size`:15})
 create (_34184:`Player` {`age`:27, `birthplace`:"Syracuse, New York, USA", `first_name`:"Andray", `height_formatted`:"6'11\"", `last_name`:"Blatche", `shoe_size`:16})
 create (_34185:`Player` {`age`:33, `birthplace`:"Pensacola, Florida, USA", `first_name`:"Reggie", `height_formatted`:"6'8\"", `last_name`:"Evans", `shoe_size`:15.5})
 create (_34186:`Player`:`AllStar` {`age`:37, `birthplace`:"Mauldin, South Carolina, USA", `first_name`:"Kevin", `height_formatted`:"6'11\"", `last_name`:"Garnett", `shoe_size`:15})
 create (_34187:`Player` {`age`:32, `birthplace`:"Little Rock, Arkansas, USA", `first_name`:"Joe", `height_formatted`:"6'8\"", `last_name`:"Johnson", `shoe_size`:16})
 create (_34188:`Player` {`age`:32, `birthplace`:"Moscow, Russian Federation", `first_name`:"Andrei", `height_formatted`:"6'9\"", `last_name`:"Kirilenko", `shoe_size`:17})
 create (_34189:`Player` {`age`:28, `birthplace`:"Peoria, Illinois, USA", `first_name`:"Shaun", `height_formatted`:"6'7\"", `last_name`:"Livingston", `shoe_size`:14})
 create (_34190:`Player`:`AllStar` {`age`:25, `birthplace`:"North Hollywood, California, USA", `first_name`:"Brook", `height_formatted`:"7'0\"", `last_name`:"Lopez", `shoe_size`:20})
 create (_34191:`Player`:`AllStar` {`age`:36, `birthplace`:"Oakland, California, USA", `first_name`:"Paul", `height_formatted`:"6'7\"", `last_name`:"Pierce", `shoe_size`:15})
 create (_34192:`Player`:`Rookie` {`age`:23, `birthplace`:"Fort Wayne, Indiana, USA", `first_name`:"Mason", `height_formatted`:"6'10\"", `last_name`:"Plumlee", `shoe_size`:17})
 create (_34193:`Player` {`age`:22, `birthplace`:"Tbilisi, Georgia", `first_name`:"Tornike", `height_formatted`:"6'8\"", `last_name`:"Shengelia", `shoe_size`:14.5})
 create (_34194:`Player` {`age`:23, `birthplace`:"Hoboken, New Jersey, USA", `first_name`:"Tyshawn", `height_formatted`:"6'3\"", `last_name`:"Taylor", `shoe_size`:13.5})
 create (_34195:`Player` {`age`:28, `birthplace`:"Mostar, Bosnia and Herzegovina", `first_name`:"Mirza", `height_formatted`:"6'9\"", `last_name`:"Teletović", `shoe_size`:15.5})
 create (_34196:`Player` {`age`:36, `birthplace`:"Seattle, Washington, USA", `first_name`:"Jason", `height_formatted`:"6'2\"", `last_name`:"Terry", `shoe_size`:12})
 create (_34197:`Player` {`age`:29, `birthplace`:"Parkersburg, West Virginia, USA", `first_name`:"Deron", `height_formatted`:"6'3\"", `last_name`:"Williams", `shoe_size`:10.5})
 create (_34198:`Team` {`abbreviation`:"CHA", `city`:"Charlotte", `full_name`:"Charlotte Bobcats"})
 create (_34199:`Player` {`age`:27, `birthplace`:"Brookline, Massachusetts, USA", `first_name`:"Jeff", `height_formatted`:"6'7\"", `last_name`:"Adrien", `shoe_size`:16})
 create (_34200:`Player` {`age`:21, `birthplace`:"Lubumbashi, Congo", `first_name`:"Bismack", `height_formatted`:"6'9\"", `last_name`:"Biyombo", `shoe_size`:16})
 create (_34201:`Player` {`age`:26, `birthplace`:"Detroit, Michigan, USA", `first_name`:"Chris", `height_formatted`:"6'7\"", `last_name`:"Douglas-Roberts", `shoe_size`:12.5})
 create (_34202:`Player` {`age`:30, `birthplace`:"London, United Kingdom", `first_name`:"Ben", `height_formatted`:"6'3\"", `last_name`:"Gordon", `shoe_size`:12})
 create (_34203:`Player` {`age`:34, `birthplace`:"New York, New York, USA", `first_name`:"Brendan", `height_formatted`:"7'0\"", `last_name`:"Haywood", `shoe_size`:18})
 create (_34204:`Player` {`age`:26, `birthplace`:"Caldwell, New Jersey, USA", `first_name`:"Gerald", `height_formatted`:"6'4\"", `last_name`:"Henderson", `shoe_size`:15})
 create (_34205:`Player` {`age`:28, `birthplace`:"Monticello, Mississippi, USA", `first_name`:"Al", `height_formatted`:"6'10\"", `last_name`:"Jefferson", `shoe_size`:18})
 create (_34206:`Player` {`age`:20, `birthplace`:"Somerdale, New Jersey, USA", `first_name`:"Michael", `height_formatted`:"6'7\"", `last_name`:"Kidd-Gilchrist", `shoe_size`:16})
 create (_34207:`Player` {`age`:26, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"Josh", `height_formatted`:"6'10\"", `last_name`:"McRoberts", `shoe_size`:18})
 create (_34208:`Player` {`age`:34, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Jannero", `height_formatted`:"6'1\"", `last_name`:"Pargo", `shoe_size`:12})
 create (_34209:`Player` {`age`:27, `birthplace`:"Myrtle Beach, South Carolina, USA", `first_name`:"Ramon", `height_formatted`:"6'3\"", `last_name`:"Sessions", `shoe_size`:12})
 create (_34210:`Player` {`age`:24, `birthplace`:"Norrköping, Sweden", `first_name`:"Jeffery", `height_formatted`:"6'7\"", `last_name`:"Taylor", `shoe_size`:13.5})
 create (_34211:`Player` {`age`:28, `birthplace`:"Springfield, Missouri, USA", `first_name`:"Anthony", `height_formatted`:"6'9\"", `last_name`:"Tolliver", `shoe_size`:14.5})
 create (_34212:`Player` {`age`:23, `birthplace`:"Bronx, New York, USA", `first_name`:"Kemba", `height_formatted`:"6'1\"", `last_name`:"Walker", `shoe_size`:11.5})
 create (_34213:`Player`:`Rookie` {`age`:21, `birthplace`:"Washington, Indiana, USA", `first_name`:"Cody", `height_formatted`:"7'0\"", `last_name`:"Zeller", `shoe_size`:16.5})
 create (_34214:`Team` {`abbreviation`:"CHI", `city`:"Chicago", `full_name`:"Chicago Bulls"})
 create (_34215:`Player` {`age`:26, `birthplace`:"New Orleans, Louisiana, USA", `first_name`:"D.J.", `height_formatted`:"6'0\"", `last_name`:"Augustin", `shoe_size`:12})
 create (_34216:`Player` {`age`:32, `birthplace`:"Aschaffenburg, Germany", `first_name`:"Carlos", `height_formatted`:"6'9\"", `last_name`:"Boozer", `shoe_size`:17})
 create (_34217:`Player` {`age`:24, `birthplace`:"Houston, Texas, USA", `first_name`:"Jimmy", `height_formatted`:"6'7\"", `last_name`:"Butler", `shoe_size`:14})
 create (_34218:`Player`:`AllStar` {`age`:28, `birthplace`:"Wau, Sudan", `first_name`:"Luol", `height_formatted`:"6'8\"", `last_name`:"Deng", `shoe_size`:15})
 create (_34219:`Player` {`age`:33, `birthplace`:"Fort Worth, Texas, USA", `first_name`:"Mike", `height_formatted`:"6'9\"", `last_name`:"Dunleavy", `shoe_size`:15})
 create (_34220:`Player` {`age`:28, `birthplace`:"San Fernando, California, USA", `first_name`:"Taj", `height_formatted`:"6'9\"", `last_name`:"Gibson", `shoe_size`:16})
 create (_34221:`Player` {`age`:32, `birthplace`:"Sioux City, Iowa, USA", `first_name`:"Kirk", `height_formatted`:"6'4\"", `last_name`:"Hinrich", `shoe_size`:13})
 create (_34222:`Player` {`age`:38, `birthplace`:"Amityville, New York, USA", `first_name`:"Mike", `height_formatted`:"6'2\"", `last_name`:"James", `shoe_size`:10.5})
 create (_34223:`Player` {`age`:36, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Nazr", `height_formatted`:"6'10\"", `last_name`:"Mohammed", `shoe_size`:17})
 create (_34224:`Player`:`Rookie` {`age`:23, `birthplace`:"Lyon, France", `first_name`:"Erik", `height_formatted`:"6'10\"", `last_name`:"Murphy", `shoe_size`:14})
 create (_34225:`Player`:`AllStar` {`age`:28, `birthplace`:"New York, New York, USA", `first_name`:"Joakim", `height_formatted`:"6'11\"", `last_name`:"Noah", `shoe_size`:15})
 create (_34226:`Player` {`age`:25, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Derrick", `height_formatted`:"6'3\"", `last_name`:"Rose", `shoe_size`:12.5})
 create (_34227:`Player`:`Rookie` {`age`:22, `birthplace`:"Los Angeles, California, USA", `first_name`:"Tony", `height_formatted`:"6'7\"", `last_name`:"Snell", `shoe_size`:12.5})
 create (_34228:`Player` {`age`:20, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"Marquis", `height_formatted`:"6'2\"", `last_name`:"Teague", `shoe_size`:12})
 create (_34229:`Team` {`abbreviation`:"CLE", `city`:"Cleveland", `full_name`:"Cleveland Cavaliers"})
 create (_34230:`Player`:`Rookie` {`age`:20, `birthplace`:"Toronto, Canada", `first_name`:"Anthony", `height_formatted`:"6'8\"", `last_name`:"Bennett", `shoe_size`:15.5})
 create (_34231:`Player` {`age`:26, `birthplace`:"Plainsboro, New Jersey, USA", `first_name`:"Andrew", `height_formatted`:"7'0\"", `last_name`:"Bynum", `shoe_size`:18})
 create (_34232:`Player` {`age`:25, `birthplace`:"Plainfield, New Jersey, USA", `first_name`:"Earl", `height_formatted`:"6'9\"", `last_name`:"Clark", `shoe_size`:14})
 create (_34233:`Player` {`age`:23, `birthplace`:"Maryborough, Australia", `first_name`:"Matthew", `height_formatted`:"6'4\"", `last_name`:"Dellavedova", `shoe_size`:12.5})
 create (_34234:`Player`:`Rookie` {`age`:23, `birthplace`:"Las Vegas, Nevada, USA", `first_name`:"Carrick", `height_formatted`:"6'6\"", `last_name`:"Felix", `shoe_size`:14.5})
 create (_34235:`Player` {`age`:26, `birthplace`:"Riviera Beach, Florida, USA", `first_name`:"Alonzo", `height_formatted`:"6'6\"", `last_name`:"Gee", `shoe_size`:14})
 create (_34236:`Player`:`AllStar` {`age`:21, `birthplace`:"West Orange, New Jersey, USA", `first_name`:"Kyrie", `height_formatted`:"6'3\"", `last_name`:"Irving", `shoe_size`:12.5})
 create (_34237:`Player` {`age`:30, `birthplace`:"Fort Washington, Maryland, USA", `first_name`:"Jarrett", `height_formatted`:"6'3\"", `last_name`:"Jack", `shoe_size`:12})
 create (_34238:`Player` {`age`:20, `birthplace`:"Saint Petersburg, Russian Federation", `first_name`:"Sergey", `height_formatted`:"6'7\"", `last_name`:"Karasev", `shoe_size`:14.5})
 create (_34239:`Player` {`age`:26, `birthplace`:"Dallas, Texas, USA", `first_name`:"C.J.", `height_formatted`:"6'6\"", `last_name`:"Miles", `shoe_size`:14})
 create (_34240:`Player` {`age`:23, `birthplace`:"Baltimore, Maryland, USA", `first_name`:"Henry", `height_formatted`:"6'10\"", `last_name`:"Sims", `shoe_size`:15.5})
 create (_34241:`Player` {`age`:22, `birthplace`:"Brampton, Canada", `first_name`:"Tristan", `height_formatted`:"6'8\"", `last_name`:"Thompson", `shoe_size`:15})
 create (_34242:`Player` {`age`:31, `birthplace`:"Santa Teresa, Brazil", `first_name`:"Anderson", `height_formatted`:"6'10\"", `last_name`:"Varejao", `shoe_size`:16})
 create (_34243:`Player` {`age`:22, `birthplace`:"Philadelphia, Pennsylvania, USA", `first_name`:"Dion", `height_formatted`:"6'4\"", `last_name`:"Waiters", `shoe_size`:13})
create (_34244:`Player` {`age`:23, `birthplace`:"Washington, Indiana, USA", `first_name`:"Tyler", `height_formatted`:"7'0\"", `last_name`:"Zeller", `shoe_size`:18})
 create (_34245:`Team` {`abbreviation`:"DAL", `city`:"Dallas", `full_name`:"Dallas Mavericks"})
 create (_34246:`Player` {`age`:24, `birthplace`:"Pittsburgh, Pennsylvania, USA", `first_name`:"DeJuan", `height_formatted`:"6'7\"", `last_name`:"Blair", `shoe_size`:14})
 create (_34247:`Player` {`age`:32, `birthplace`:"Villanueva de la Serena, Spain", `first_name`:"Jose", `height_formatted`:"6'3\"", `last_name`:"Calderon", `shoe_size`:13})
 create (_34248:`Player` {`age`:36, `birthplace`:"Daytona Beach, Florida, USA", `first_name`:"Vince", `height_formatted`:"6'6\"", `last_name`:"Carter", `shoe_size`:16.5})
 create (_34249:`Player` {`age`:23, `birthplace`:"Villa Rica, Georgia, USA", `first_name`:"Jae", `height_formatted`:"6'6\"", `last_name`:"Crowder", `shoe_size`:15})
 create (_34250:`Player` {`age`:32, `birthplace`:"Port-au-Prince, Haiti", `first_name`:"Samuel", `height_formatted`:"6'11\"", `last_name`:"Dalembert", `shoe_size`:16})
 create (_34251:`Player` {`age`:26, `birthplace`:"Wynnewood, Pennsylvania, USA", `first_name`:"Wayne", `height_formatted`:"6'4\"", `last_name`:"Ellington", `shoe_size`:13})
 create (_34252:`Player` {`age`:28, `birthplace`:"Jackson, Mississippi, USA", `first_name`:"Monta", `height_formatted`:"6'3\"", `last_name`:"Ellis", `shoe_size`:13})
 create (_34253:`Player` {`age`:30, `birthplace`:"Milwaukee, Wisconsin, USA", `first_name`:"Devin", `height_formatted`:"6'3\"", `last_name`:"Harris", `shoe_size`:12.5})
 create (_34254:`Player` {`age`:28, `birthplace`:"Savannah, Georgia, USA", `first_name`:"Bernard", `height_formatted`:"6'10\"", `last_name`:"James", `shoe_size`:16})
 create (_34255:`Player`:`Rookie` {`age`:21, `birthplace`:"Cincinnati, Ohio, USA", `first_name`:"DeShane", `height_formatted`:"5'11\"", `last_name`:"Larkin", `shoe_size`:11.5})
 create (_34256:`Player`:`Rookie` {`age`:21, `birthplace`:"Providence, Rhode Island, USA", `first_name`:"Ricardo", `height_formatted`:"6'7\"", `last_name`:"Ledo", `shoe_size`:13.5})
 create (_34257:`Player` {`age`:35, `birthplace`:"Waukegan, Illinois, USA", `first_name`:"Shawn", `height_formatted`:"6'7\"", `last_name`:"Marion", `shoe_size`:14})
 create (_34258:`Player` {`age`:25, `birthplace`:"Hasharon, Israel", `first_name`:"Gal", `height_formatted`:"6'3\"", `last_name`:"Mekel", `shoe_size`:14.5})
 create (_34259:`Player` {`age`:35, `birthplace`:"Würzburg, Germany", `first_name`:"Dirk", `height_formatted`:"6'11\"", `last_name`:"Nowitzki", `shoe_size`:16})
 create (_34260:`Player` {`age`:26, `birthplace`:"Nashville, Tennessee, USA", `first_name`:"Brandan", `height_formatted`:"6'9\"", `last_name`:"Wright", `shoe_size`:15})
 create (_34261:`Team` {`abbreviation`:"DEN", `city`:"Denver", `full_name`:"Denver Nuggets"})
 create (_34262:`Player` {`age`:25, `birthplace`:"Dallas, Texas, USA", `first_name`:"Darrell", `height_formatted`:"6'9\"", `last_name`:"Arthur", `shoe_size`:14.5})
 create (_34263:`Player` {`age`:26, `birthplace`:"Benton Harbor, Michigan, USA", `first_name`:"Wilson", `height_formatted`:"6'8\"", `last_name`:"Chandler",`shoe_size`:15.5})
 create (_34264:`Player` {`age`:24, `birthplace`:"Newark, New Jersey, USA", `first_name`:"Kenneth", `height_formatted`:"6'8\"", `last_name`:"Faried", `shoe_size`:16})
 create (_34265:`Player` {`age`:21, `birthplace`:"Saint-Maurice, France", `first_name`:"Evan", `height_formatted`:"6'7\"", `last_name`:"Fournier",`shoe_size`:13.5})
 create (_34266:`Player` {`age`:30, `birthplace`:"Newark, New Jersey, USA", `first_name`:"Randy", `height_formatted`:"6'4\"", `last_name`:"Foye", `shoe_size`:13})
 create (_34267:`Player` {`age`:25, `birthplace`:"Sant'Angelo Lodigiano, Italy", `first_name`:"Danilo", `height_formatted`:"6'8\"", `last_name`:"Gallinari", `shoe_size`:16})
 create (_34268:`Player` {`age`:23, `birthplace`:"Los Angeles, California, USA", `first_name`:"Jordan", `height_formatted`:"6'7\"", `last_name`:"Hamilton", `shoe_size`:14})
 create (_34269:`Player` {`age`:25, `birthplace`:"Atlanta, Georgia, USA", `first_name`:"J.J.", `height_formatted`:"6'9\"", `last_name`:"Hickson", `shoe_size`:14})
 create (_34270:`Player` {`age`:26, `birthplace`:"Clinton, Maryland, USA", `first_name`:"Ty", `height_formatted`:"5'11\"", `last_name`:"Lawson", `shoe_size`:12})
 create (_34271:`Player` {`age`:25, `birthplace`:"Flint, Michigan, USA", `first_name`:"JaVale", `height_formatted`:"7'0\"", `last_name`:"McGee", `shoe_size`:20})
 create (_34272:`Player` {`age`:37, `birthplace`:"Los Angeles, California, USA", `first_name`:"Andre", `height_formatted`:"6'2\"", `last_name`:"Miller", `shoe_size`:13.5})
 create (_34273:`Player` {`age`:21, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Quincy", `height_formatted`:"6'10\"", `last_name`:"Miller",`shoe_size`:16.5})
 create (_34274:`Player` {`age`:27, `birthplace`:"Saint Petersburg, Russian Federation", `first_name`:"Timofey", `height_formatted`:"7'1\"", `last_name`:"Mozgov", `shoe_size`:18})
 create (_34275:`Player` {`age`:24, `birthplace`:"Wurzbach, Germany", `first_name`:"Anthony", `height_formatted`:"6'10\"", `last_name`:"Randolph", `shoe_size`:14})
 create (_34276:`Player` {`age`:29, `birthplace`:"Seattle, Washington, USA", `first_name`:"Nate", `height_formatted`:"5'9\"", `last_name`:"Robinson", `shoe_size`:10.5})
 create (_34277:`Team` {`abbreviation`:"DET", `city`:"Auburn Hills", `full_name`:"Detroit Pistons"})
 create (_34278:`Player` {`age`:37, `birthplace`:"Denver, Colorado, USA", `first_name`:"Chauncey", `height_formatted`:"6'3\"", `last_name`:"Billups", `shoe_size`:14})
 create (_34279:`Player` {`age`:30, `birthplace`:"Chicago, Illinois, USA", `first_name`:"William", `height_formatted`:"6'0\"", `last_name`:"Bynum", `shoe_size`:12})
 create (_34280:`Player`:`Rookie` {`age`:20, `birthplace`:"Thomaston, Georgia, USA", `first_name`:"Kentavious", `height_formatted`:"6'6\"", `last_name`:"Caldwell-Pope", `shoe_size`:12})
 create (_34281:`Player` {`age`:26, `birthplace`:"Montebelluna, Italy", `first_name`:"Luigi", `height_formatted`:"6'8\"", `last_name`:"Datome", `shoe_size`:17.5})
 create (_34282:`Player` {`age`:20, `birthplace`:"Middletown, Connecticut, USA", `first_name`:"Andre", `height_formatted`:"6'11\"", `last_name`:"Drummond", `shoe_size`:18})
 create (_34283:`Player` {`age`:24, `birthplace`:"Saint Charles, Missouri, USA", `first_name`:"Josh", `height_formatted`:"6'10\"", `last_name`:"Harrellson", `shoe_size`:16.5})
 create (_34284:`Player` {`age`:24, `birthplace`:"Los Angeles, California, USA", `first_name`:"Brandon", `height_formatted`:"6'1\"", `last_name`:"Jennings", `shoe_size`:11.5})
 create (_34285:`Player` {`age`:26, `birthplace`:"Kinna, Sweden", `first_name`:"Jonas", `height_formatted`:"6'9\"", `last_name`:"Jerebko", `shoe_size`:15})
 create (_34286:`Player`:`Rookie` {`age`:21, `birthplace`:"Milwaukee, Wisconsin, USA", `first_name`:"Tony", `height_formatted`:"6'9\"", `last_name`:"Mitchell", `shoe_size`:17})
 create (_34287:`Player` {`age`:23, `birthplace`:"Harvey, Louisiana, USA", `first_name`:"Greg", `height_formatted`:"6'11\"", `last_name`:"Monroe", `shoe_size`:14})
 create (_34288:`Player` {`age`:25, `birthplace`:"Medford, Oregon, USA", `first_name`:"Kyle", `height_formatted`:"6'8\"", `last_name`:"Singler", `shoe_size`:14.5})
 create (_34289:`Player`:`Rookie` {`age`:23, `birthplace`:"Seattle, Washington, USA", `first_name`:"Peyton", `height_formatted`:"6'0\"", `last_name`:"Siva", `shoe_size`:11.5})
 create (_34290:`Player` {`age`:28, `birthplace`:"College Park, Georgia, USA", `first_name`:"Josh", `height_formatted`:"6'9\"", `last_name`:"Smith", `shoe_size`:13.5})
 create (_34291:`Player` {`age`:27, `birthplace`:"Seattle, Washington, USA", `first_name`:"Rodney", `height_formatted`:"6'5\"", `last_name`:"Stuckey", `shoe_size`:13})
 create (_34292:`Player` {`age`:29, `birthplace`:"Queens, New York, USA", `first_name`:"Charlie", `height_formatted`:"6'11\"", `last_name`:"Villanueva", `shoe_size`:13})
 create (_34293:`Team` {`abbreviation`:"GS", `city`:"Oakland", `full_name`:"Golden State Warriors"})
 create (_34294:`Player` {`age`:29, `birthplace`:"Peekskill, New York, USA", `first_name`:"Hilton", `height_formatted`:"6'11\"", `last_name`:"Armstrong", `shoe_size`:16.5})
 create (_34295:`Player` {`age`:21, `birthplace`:"Ames, Iowa, USA", `first_name`:"Harrison", `height_formatted`:"6'8\"", `last_name`:"Barnes", `shoe_size`:14})
 create (_34296:`Player` {`age`:24, `birthplace`:"Kelford, North Carolina, USA", `first_name`:"Kent", `height_formatted`:"6'5\"", `last_name`:"Bazemore", `shoe_size`:13})
 create (_34297:`Player` {`age`:29, `birthplace`:"Melbourne, Australia", `first_name`:"Andrew", `height_formatted`:"7'0\"", `last_name`:"Bogut", `shoe_size`:18})
 create (_34298:`Player` {`age`:25, `birthplace`:"Akron, Ohio, USA", `first_name`:"Stephen", `height_formatted`:"6'3\"", `last_name`:"Curry", `shoe_size`:13})
 create (_34299:`Player` {`age`:27, `birthplace`:"Jonesboro, Georgia, USA", `first_name`:"Toney", `height_formatted`:"6'2\"", `last_name`:"Douglas", `shoe_size`:13})
 create (_34300:`Player` {`age`:24, `birthplace`:"Benin-City, Nigeria", `first_name`:"Ifeanyi", `height_formatted`:"6'11\"", `last_name`:"Ezeli", `shoe_size`:18})
 create (_34301:`Player` {`age`:23, `birthplace`:"Saginaw, Michigan, USA", `first_name`:"Draymond", `height_formatted`:"6'7\"", `last_name`:"Green", `shoe_size`:15})
 create (_34302:`Player` {`age`:29, `birthplace`:"Springfield, Illinois, USA", `first_name`:"Andre", `height_formatted`:"6'6\"", `last_name`:"Iguodala", `shoe_size`:17})
 create (_34303:`Player` {`age`:23, `birthplace`:"Doboj, Bosnia and Herzegovina", `first_name`:"Ognjen", `height_formatted`:"7'1\"", `last_name`:"Kuzmifa", `shoe_size`:16.5})
 create (_34304:`Player`:`AllStar` {`age`:30, `birthplace`:"Saint Louis, Missouri, USA", `first_name`:"David", `height_formatted`:"6'9\"", `last_name`:"Lee", `shoe_size`:15})
 create (_34305:`Player`:`Rookie` {`age`:22, `birthplace`:"Nova Varo≈°, Serbia and Montenegro", `first_name`:"Nemanja", `height_formatted`:"6'3\"", `last_name`:"Nedović", `shoe_size`:14.5})
 create (_34306:`Player` {`age`:35, `birthplace`:"Columbia, South Carolina, USA", `first_name`:"Jermaine", `height_formatted`:"6'11\"", `last_name`:"O'Neal", `shoe_size`:15})
 create (_34307:`Player` {`age`:26, `birthplace`:"Saint Petersburg, Florida, USA", `first_name`:"Marreese", `height_formatted`:"6'10\"", `last_name`:"Speights", `shoe_size`:16.5})
 create (_34308:`Player` {`age`:23, `birthplace`:"Los Angeles, California, USA", `first_name`:"Klay", `height_formatted`:"6'7\"", `last_name`:"Thompson", `shoe_size`:15})
 create (_34309:`Team` {`abbreviation`:"HOU", `city`:"Houston", `full_name`:"Houston Rockets"})
 create (_34310:`Player` {`age`:27, `birthplace`:"Bursa, Turkey", `first_name`:"Omer", `height_formatted`:"7'0\"", `last_name`:"Asik", `shoe_size`:17})
 create (_34311:`Player` {`age`:25, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Patrick", `height_formatted`:"6'1\"", `last_name`:"Beverley", `shoe_size`:13})
 create (_34312:`Player` {`age`:28, `birthplace`:"Portland, Oregon, USA", `first_name`:"Ronnie", `height_formatted`:"6'7\"", `last_name`:"Brewer", `shoe_size`:14})
 create (_34313:`Player` {`age`:28, `birthplace`:"Seattle, Washington, USA", `first_name`:"Aaron", `height_formatted`:"6'0\"", `last_name`:"Brooks", `shoe_size`:12})
 create (_34314:`Player`:`Rookie` {`age`:22, `birthplace`:"Biloxi, Mississippi, USA", `first_name`:"Isaiah", `height_formatted`:"6'1\"", `last_name`:"Canaan", `shoe_size`:9.5})
 create (_34315:`Player` {`age`:25, `birthplace`:"Yavne, Israel", `first_name`:"Omri", `height_formatted`:"6'7\"", `last_name`:"Casspi", `shoe_size`:13})
 create (_34316:`Player` {`age`:23, `birthplace`:"Bellwood, Illinois, USA", `first_name`:"Robert", `height_formatted`:"6'9\"", `last_name`:"Covington", `shoe_size`:14.5})
 create (_34317:`Player` {`age`:31, `birthplace`:"Santo Domingo, Dominican Republic", `first_name`:"Francisco", `height_formatted`:"6'7\"", `last_name`:"Garcia", `shoe_size`:15})
 create (_34318:`Player`:`AllStar` {`age`:24, `birthplace`:"Los Angeles, California, USA", `first_name`:"James", `height_formatted`:"6'5\"", `last_name`:"Harden", `shoe_size`:14})
 create (_34319:`Player`:`AllStar` {`age`:28, `birthplace`:"Atlanta, Georgia, USA", `first_name`:"Dwight", `height_formatted`:"6'11\"", `last_name`:"Howard", `shoe_size`:18})
 create (_34320:`Player` {`age`:21, `birthplace`:"Portland, Oregon, USA", `first_name`:"Terrence", `height_formatted`:"6'9\"", `last_name`:"Jones", `shoe_size`:15})
 create (_34321:`Player` {`age`:25, `birthplace`:"Palo Alto, California, USA", `first_name`:"Jeremy", `height_formatted`:"6'3\"", `last_name`:"Lin", `shoe_size`:12})
 create (_34322:`Player` {`age`:23, `birthplace`:"Kaunas, Lithuania", `first_name`:"Donatas", `height_formatted`:"7'0\"", `last_name`:"Motiejunas", `shoe_size`:17})
 create (_34323:`Player` {`age`:25, `birthplace`:"Casselberry, Florida, USA", `first_name`:"Chandler", `height_formatted`:"6'9\"", `last_name`:"Parsons", `shoe_size`:15})
 create (_34324:`Player` {`age`:22, `birthplace`:"Fresno, California, USA", `first_name`:"Greg", `height_formatted`:"6'10\"", `last_name`:"Smith", `shoe_size`:17})
 create (_34325:`Team` {`abbreviation`:"IND", `city`:"Indianapolis", `full_name`:"Indiana Pacers"})
 create (_34326:`Player` {`age`:34, `birthplace`:"Philadelphia, Pennsylvania, USA", `first_name`:"Rasual", `height_formatted`:"6'7\"", `last_name`:"Butler", `shoe_size`:14.5})
 create (_34327:`Player` {`age`:29, `birthplace`:"Richmond, Virginia, USA", `first_name`:"Chris", `height_formatted`:"6'8\"", `last_name`:"Copeland", `shoe_size`:14})
 create (_34328:`Player`:`AllStar` {`age`:33, `birthplace`:"Palmdale, California, USA", `first_name`:"Paul", `height_formatted`:"6'8\"", `last_name`:"George", `shoe_size`:13})
 create (_34329:`Player` {`age`:30, `birthplace`:"New Orleans, Louisiana, USA", `first_name`:"Danny", `height_formatted`:"6'8\"", `last_name`:"Granger", `shoe_size`:15.5})
 create (_34330:`Player` {`age`:27, `birthplace`:"Queens, New York, USA", `first_name`:"Roy", `height_formatted`:"7'2\"", `last_name`:"Hibbert", `shoe_size`:17})
 create (_34331:`Player` {`age`:27, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"George", `height_formatted`:"6'2\"", `last_name`:"Hill", `shoe_size`:13.5})
 create (_34332:`Player`:`Rookie` {`age`:22, `birthplace`:"Los Angeles, California, USA", `first_name`:"Solomon", `height_formatted`:"6'7\"", `last_name`:"Hill", `shoe_size`:16})
 create (_34333:`Player` {`age`:24, `birthplace`:"Seaside, California, USA", `first_name`:"Orlando", `height_formatted`:"6'5\"", `last_name`:"Johnson", `shoe_size`:16})
 create (_34334:`Player` {`age`:27, `birthplace`:"Rouen, France", `first_name`:"Ian", `height_formatted`:"6'10\"", `last_name`:"Mahinmi", `shoe_size`:16})
 create (_34335:`Player` {`age`:33, `birthplace`:"Buenos Aires, Argentina", `first_name`:"Luis", `height_formatted`:"6'9\"", `last_name`:"Scola", `shoe_size`:17})
 create (_34336:`Player` {`age`:25, `birthplace`:"Shreveport, Louisiana, USA", `first_name`:"Donald", `height_formatted`:"6'3\"", `last_name`:"Sloan", `shoe_size`:12.5})
 create (_34337:`Player` {`age`:23, `birthplace`:"Brooklyn, New York, USA", `first_name`:"Lance", `height_formatted`:"6'5\"", `last_name`:"Stephenson", `shoe_size`:14})
 create (_34338:`Player` {`age`:29, `birthplace`:"Las Vegas, Nevada, USA", `first_name`:"Charles", `height_formatted`:"6'2\"", `last_name`:"Watson", `shoe_size`:10.5})
 create (_34339:`Player` {`age`:33, `birthplace`:"Teaneck, New Jersey, USA", `first_name`:"David", `height_formatted`:"6'9\"", `last_name`:"West", `shoe_size`:17})
 create (_34340:`Team` {`abbreviation`:"LAC", `city`:"Los Angeles", `full_name`:"Los Angeles Clippers"})
 create (_34341:`Player` {`age`:33, `birthplace`:"Citrus Heights, California, USA", `first_name`:"Matt", `height_formatted`:"6'7\"", `last_name`:"Barnes", `shoe_size`:15})
 create (_34342:`Player`:`Rookie` {`age`:22, `birthplace`:"Kinston, North Carolina, USA", `first_name`:"Reginald", `height_formatted`:"6'7\"", `last_name`:"Bullock", `shoe_size`:13.5})
create (_34343:`Player` {`age`:26, `birthplace`:"Rancho Cucamonga, California, USA", `first_name`:"Darren", `height_formatted`:"6'0\"", `last_name`:"Collison", `shoe_size`:11.5})
 create (_34344:`Player` {`age`:33, `birthplace`:"Seattle, Washington, USA", `first_name`:"Jamal", `height_formatted`:"6'6\"", `last_name`:"Crawford", `shoe_size`:14})
 create (_34345:`Player` {`age`:28, `birthplace`:"San Diego, California, USA", `first_name`:"Jared", `height_formatted`:"6'7\"", `last_name`:"Dudley", `shoe_size`:16})
 create (_34346:`Player` {`age`:32, `birthplace`:"Detroit, Michigan, USA", `first_name`:"Willie", `height_formatted`:"6'3\"", `last_name`:"Green", `shoe_size`:13.5})
 create (_34347:`Player`:`AllStar` {`age`:24, `birthplace`:"Oklahoma City, Oklahoma, USA", `first_name`:"Blake", `height_formatted`:"6'10\"", `last_name`:"Griffin", `shoe_size`:17})
 create (_34348:`Player` {`age`:29, `birthplace`:"Pasadena, California, USA", `first_name`:"Ryan", `height_formatted`:"7'0\"", `last_name`:"Hollins", `shoe_size`:17})
 create (_34349:`Player` {`age`:35, `birthplace`:"Houston, Texas, USA", `first_name`:"Stephen", `height_formatted`:"6'8\"", `last_name`:"Jackson", `shoe_size`:14})
 create (_34350:`Player` {`age`:37, `birthplace`:"Shreveport, Louisiana, USA", `first_name`:"Antawn", `height_formatted`:"6'8\"", `last_name`:"Jamison", `shoe_size`:16})
 create (_34351:`Player` {`age`:25, `birthplace`:"Houston, Texas, USA", `first_name`:"DeAndre", `height_formatted`:"7'0\"", `last_name`:"Jordan", `shoe_size`:17})
 create (_34352:`Player` {`age`:24, `birthplace`:"Canal Winchester, Ohio, USA", `first_name`:"Byron", `height_formatted`:"7'0\"", `last_name`:"Mullens", `shoe_size`:16})
 create (_34353:`Player`:`AllStar` {`age`:28, `birthplace`:"Winston-Salem, North Carolina, USA", `first_name`:"Chris", `height_formatted`:"6'0\"", `last_name`:"Paul", `shoe_size`:12.5})
 create (_34354:`Player` {`age`:29, `birthplace`:"Cookeville, Tennessee, USA", `first_name`:"J.J.", `height_formatted`:"6'4\"", `last_name`:"Redick", `shoe_size`:13.5})
 create (_34355:`Player` {`age`:22, `birthplace`:"Philadelphia, Pennsylvania, USA", `first_name`:"Maalik", `height_formatted`:"6'1\"", `last_name`:"Wayns", `shoe_size`:12.5})
 create (_34356:`Team` {`abbreviation`:"LAL", `city`:"Los Angeles", `full_name`:"Los Angeles Lakers"})
 create (_34357:`Player` {`age`:33, `birthplace`:"Hollywood, Florida, USA", `first_name`:"Steve", `height_formatted`:"6'3\"", `last_name`:"Blake", `shoe_size`:13})
 create (_34358:`Player`:`AllStar` {`age`:35, `birthplace`:"Philadelphia, Pennsylvania, USA", `first_name`:"Kobe", `height_formatted`:"6'6\"", `last_name`:"Bryant", `shoe_size`:14})
 create (_34359:`Player` {`age`:27, `birthplace`:"Los Angeles, California, USA", `first_name`:"Jordan", `height_formatted`:"6'2\"", `last_name`:"Farmar", `shoe_size`:11})
 create (_34360:`Player` {`age`:33, `birthplace`:"Barcelona, Spain", `first_name`:"Pau", `height_formatted`:"7'0\"", `last_name`:"Gasol", `shoe_size`:17})
 create (_34361:`Player` {`age`:22, `birthplace`:"Ghent, Belgium", `first_name`:"Xavier", `height_formatted`:"6'6\"", `last_name`:"Henry", `shoe_size`:16})
 create (_34362:`Player` {`age`:26, `birthplace`:"Atlanta, Georgia, USA", `first_name`:"Jordan", `height_formatted`:"6'10\"", `last_name`:"Hill", `shoe_size`:15})
 create (_34363:`Player` {`age`:26, `birthplace`:"Corsicana, Texas, USA", `first_name`:"Wesley", `height_formatted`:"6'7\"", `last_name`:"Johnson", `shoe_size`:14.5})
 create (_34364:`Player` {`age`:31, `birthplace`:"Wyoming, Michigan, USA", `first_name`:"Chris", `height_formatted`:"7'0\"", `last_name`:"Kaman", `shoe_size`:17})
 create (_34365:`Player`:`Rookie` {`age`:22, `birthplace`:"Carmel, New York, USA", `first_name`:"Ryan", `height_formatted`:"6'11\"", `last_name`:"Kelly", `shoe_size`:12})
 create (_34366:`Player` {`age`:26, `birthplace`:"Norcross, Georgia, USA", `first_name`:"Jodie", `height_formatted`:"6'4\"", `last_name`:"Meeks", `shoe_size`:13})
 create (_34367:`Player` {`age`:39, `birthplace`:"Johannesburg, South Africa", `first_name`:"Steve", `height_formatted`:"6'3\"", `last_name`:"Nash", `shoe_size`:11.5})
 create (_34368:`Player` {`age`:24, `birthplace`:"North Vancouver, Canada", `first_name`:"Robert", `height_formatted`:"7'0\"", `last_name`:"Sacre", `shoe_size`:16})
 create (_34369:`Player` {`age`:27, `birthplace`:"Memphis, Tennessee, USA", `first_name`:"Shawne", `height_formatted`:"6'9\"", `last_name`:"Williams", `shoe_size`:15.5})
 create (_34370:`Player` {`age`:28, `birthplace`:"Reseda, California, USA", `first_name`:"Nick", `height_formatted`:"6'7\"", `last_name`:"Young", `shoe_size`:13})
 create (_34371:`Team` {`abbreviation`:"MEM", `city`:"Memphis", `full_name`:"Memphis Grizzlies"})
 create (_34372:`Player` {`age`:31, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Tony", `height_formatted`:"6'4\"", `last_name`:"Allen", `shoe_size`:13})
 create (_34373:`Player` {`age`:25, `birthplace`:"Phoenix, Arizona, USA", `first_name`:"Jerryd", `height_formatted`:"6'3\"", `last_name`:"Bayless", `shoe_size`:13.5})
 create (_34374:`Player` {`age`:24, `birthplace`:"Casselberry, Florida, USA", `first_name`:"Nick", `height_formatted`:"6'6\"", `last_name`:"Calathes", `shoe_size`:14})
 create (_34375:`Player` {`age`:26, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"Mike", `height_formatted`:"6'1\"", `last_name`:"Conley", `shoe_size`:12})
 create (_34376:`Player` {`age`:24, `birthplace`:"Washington, District of Columbia, USA", `first_name`:"Ed", `height_formatted`:"6'10\"", `last_name`:"Davis", `shoe_size`:14.5})
 create (_34377:`Player`:`Rookie` {`age`:22, `birthplace`:"Moreno Valley, California, USA", `first_name`:"Jamaal", `height_formatted`:"6'5\"", `last_name`:"Franklin", `shoe_size`:15})
 create (_34378:`Player` {`age`:28, `birthplace`:"Barcelona, Spain", `first_name`:"Marc", `height_formatted`:"7'0\"", `last_name`:"Gasol", `shoe_size`:17})
 create (_34379:`Player` {`age`:24, `birthplace`:"Canton, Ohio, USA", `first_name`:"Konstantine", `height_formatted`:"7'0\"", `last_name`:"Koufos", `shoe_size`:19.5})
 create (_34380:`Player` {`age`:24, `birthplace`:"Long Lake, Minnesota, USA", `first_name`:"Jon", `height_formatted`:"6'10\"", `last_name`:"Leuer", `shoe_size`:16})
 create (_34381:`Player` {`age`:33, `birthplace`:"Mitchell, South Dakota, USA", `first_name`:"Mike", `height_formatted`:"6'8\"", `last_name`:"Miller", `shoe_size`:14})
 create (_34382:`Player` {`age`:25, `birthplace`:"Fresno, California, USA", `first_name`:"Quincy", `height_formatted`:"6'6\"", `last_name`:"Pondexter", `shoe_size`:15})
 create (_34383:`Player` {`age`:33, `birthplace`:"Compton, California, USA", `first_name`:"Tayshaun", `height_formatted`:"6'9\"", `last_name`:"Prince", `shoe_size`:15})
 create (_34384:`Player`:`AllStar` {`age`:32, `birthplace`:"Marion, Indiana, USA", `first_name`:"Zach", `height_formatted`:"6'9\"", `last_name`:"Randolph", `shoe_size`:15.5})
 create (_34385:`Team` {`abbreviation`:"MIA", `city`:"Miami", `full_name`:"Miami Heat"})
 create (_34386:`Player` {`age`:38, `birthplace`:"Merced, California, USA", `first_name`:"Ray", `height_formatted`:"6'5\"", `last_name`:"Allen", `shoe_size`:15})
 create (_34387:`Player` {`age`:35, `birthplace`:"Long Beach, California, USA", `first_name`:"Chris", `height_formatted`:"6'10\"", `last_name`:"Andersen", `shoe_size`:15.5})
 create (_34388:`Player` {`age`:31, `birthplace`:"Montreal, Canada", `first_name`:"Joel", `height_formatted`:"6'9\"", `last_name`:"Anthony", `shoe_size`:17})
 create (_34389:`Player` {`age`:35, `birthplace`:"Birmingham, Michigan, USA", `first_name`:"Shane", `height_formatted`:"6'8\"", `last_name`:"Battier", `shoe_size`:15})
 create (_34390:`Player` {`age`:24, `birthplace`:"Frederick, Maryland, USA", `first_name`:"Michael", `height_formatted`:"6'10\"", `last_name`:"Beasley",`shoe_size`:15.5})
 create (_34391:`Player`:`AllStar` {`age`:29, `birthplace`:"Dallas, Texas, USA", `first_name`:"Chris", `height_formatted`:"6'10\"", `last_name`:"Bosh", `shoe_size`:14.5})
 create (_34392:`Player` {`age`:27, `birthplace`:"Anchorage, Alaska, USA", `first_name`:"Mario", `height_formatted`:"6'1\"", `last_name`:"Chalmers", `shoe_size`:13})
 create (_34393:`Player` {`age`:25, `birthplace`:"Dayton, Ohio, USA", `first_name`:"Norris", `height_formatted`:"6'2\"", `last_name`:"Cole", `shoe_size`:12})
 create (_34394:`Player` {`age`:33, `birthplace`:"Miami, Florida, USA", `first_name`:"Udonis", `height_formatted`:"6'8\"", `last_name`:"Haslem", `shoe_size`:18})
 create (_34395:`Player`:`AllStar` {`age`:28, `birthplace`:"Akron, Ohio, USA", `first_name`:"LeBron", `height_formatted`:"6'8\"", `last_name`:"James", `shoe_size`:16})
 create (_34396:`Player` {`age`:33, `birthplace`:"Miami, Florida, USA", `first_name`:"James", `height_formatted`:"6'8\"", `last_name`:"Jones", `shoe_size`:18})
 create (_34397:`Player` {`age`:34, `birthplace`:"Pineville, Louisiana, USA", `first_name`:"Rashard", `height_formatted`:"6'10\"", `last_name`:"Lewis", `shoe_size`:14})
 create (_34398:`Player` {`age`:33, `birthplace`:"Washington, District of Columbia, USA", `first_name`:"Roger", `height_formatted`:"6'5\"", `last_name`:"Mason", `shoe_size`:14})
 create (_34399:`Player` {`age`:25, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"Greg", `height_formatted`:"7'0\"", `last_name`:"Oden", `shoe_size`:20})
 create (_34400:`Player`:`AllStar` {`age`:31, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Dwyane", `height_formatted`:"6'4\"", `last_name`:"Wade", `shoe_size`:15.5})
 create (_34401:`Team` {`abbreviation`:"MIL", `city`:"Milwaukee", `full_name`:"Milwaukee Bucks"})
 create (_34402:`Player`:`Rookie` {`age`:18, `birthplace`:"Athens, Greece", `first_name`:"Giannis", `height_formatted`:"6'10\"", `last_name`:"Antetokounmpo", `shoe_size`:15.5})
 create (_34403:`Player` {`age`:33, `birthplace`:"Racine, Wisconsin, USA", `first_name`:"Caron", `height_formatted`:"6'7\"", `last_name`:"Butler", `shoe_size`:14})
 create (_34404:`Player` {`age`:31, `birthplace`:"Santa Fe, Argentina", `first_name`:"Carlos", `height_formatted`:"6'6\"", `last_name`:"Delfino", `shoe_size`:16})
 create (_34405:`Player` {`age`:22, `birthplace`:"Tampa, Florida, USA", `first_name`:"John", `height_formatted`:"6'11\"", `last_name`:"Henson", `shoe_size`:18})
 create (_34406:`Player` {`age`:26, `birthplace`:"Eskişehir, Turkey", `first_name`:"Ersan", `height_formatted`:"6'9\"", `last_name`:"Ilyasova", `shoe_size`:16})
 create (_34407:`Player` {`age`:22, `birthplace`:"East Orange, New Jersey, USA", `first_name`:"Brandon", `height_formatted`:"6'3\"", `last_name`:"Knight", `shoe_size`:12.5})
 create (_34408:`Player` {`age`:26, `birthplace`:"Huntington, West Virginia, USA", `first_name`:"O.J.", `height_formatted`:"6'5\"", `last_name`:"Mayo", `shoe_size`:14})
 create (_34409:`Player` {`age`:22, `birthplace`:"North Charleston, South Carolina, USA", `first_name`:"Khris", `height_formatted`:"6'7\"", `last_name`:"Middleton", `shoe_size`:16})
 create (_34410:`Player` {`age`:29, `birthplace`:"Baltimore, Maryland, USA", `first_name`:"Gary", `height_formatted`:"6'4\"", `last_name`:"Neal", `shoe_size`:13})
 create (_34411:`Player` {`age`:29, `birthplace`:"Tbilisi, Georgia", `first_name`:"Zaza", `height_formatted`:"6'11\"", `last_name`:"Pachulia", `shoe_size`:17})
 create (_34412:`Player` {`age`:25, `birthplace`:"Belgrade, Serbia and Montenegro", `first_name`:"Miroslav", `height_formatted`:"7'0\"", `last_name`:"Raduljica", `shoe_size`:19})
 create (_34413:`Player` {`age`:32, `birthplace`:"Coeur d'Alene, Idaho, USA", `first_name`:"Luke", `height_formatted`:"6'2\"", `last_name`:"Ridnour", `shoe_size`:11.5})
 create (_34414:`Player` {`age`:25, `birthplace`:"Fort Pierce, Florida, USA", `first_name`:"Larry", `height_formatted`:"6'11\"", `last_name`:"Sanders", `shoe_size`:18})
 create (_34415:`Player` {`age`:26, `birthplace`:"Edmond, Oklahoma, USA", `first_name`:"Ekpe", `height_formatted`:"6'10\"", `last_name`:"Udoh", `shoe_size`:16})
 create (_34416:`Player`:`Rookie` {`age`:22, `birthplace`:"Saint Cloud, Minnesota, USA", `first_name`:"Nate", `height_formatted`:"6'4\"", `last_name`:"Wolters", `shoe_size`:11})
 create (_34417:`Team` {`abbreviation`:"MIN", `city`:"Minneapolis", `full_name`:"Minnesota Timberwolves"})
 create (_34418:`Player` {`age`:29, `birthplace`:"Mayaguez, Puerto Rico", `first_name`:"J.J.", `height_formatted`:"6'0\"", `last_name`:"Barea", `shoe_size`:12})
 create (_34419:`Player` {`age`:27, `birthplace`:"Portland, Tennessee, USA", `first_name`:"Corey", `height_formatted`:"6'9\"", `last_name`:"Brewer", `shoe_size`:13.5})
 create (_34420:`Player` {`age`:25, `birthplace`:"Encinitas, California, USA", `first_name`:"Chase", `height_formatted`:"6'7\"", `last_name`:"Budinger", `shoe_size`:14})
 create (_34421:`Player` {`age`:26, `birthplace`:"Clinton, Maryland, USA", `first_name`:"Dante", `height_formatted`:"6'8\"", `last_name`:"Cunningham", `shoe_size`:18})
 create (_34422:`Player`:`Rookie` {`age`:23, `birthplace`:"Kébémèr, Senegal", `first_name`:"Gorgui", `height_formatted`:"6'11\"", `last_name`:"Dieng", `shoe_size`:12.5})
 create (_34423:`Player` {`age`:24, `birthplace`:"Valparaiso, Indiana, USA", `first_name`:"Robert", `height_formatted`:"6'8\"", `last_name`:"Hummel", `shoe_size`:16.5})
 create (_34424:`Player` {`age`:25, `birthplace`:"Santa Monica, California, USA", `first_name`:"Kevin", `height_formatted`:"6'10\"", `last_name`:"Love", `shoe_size`:18})
 create (_34425:`Player` {`age`:30, `birthplace`:"Zanesville, Ohio, USA", `first_name`:"Kevin", `height_formatted`:"6'7\"", `last_name`:"Martin", `shoe_size`:12})
 create (_34426:`Player` {`age`:27, `birthplace`:"Yaoundé, Cameroon", `first_name`:"Luc Richard", `height_formatted`:"6'8\"", `last_name`:"Mbah a Moute", `shoe_size`:14})
 create (_34427:`Player`:`Rookie` {`age`:21, `birthplace`:"Long Beach, California, USA", `first_name`:"Shabazz", `height_formatted`:"6'6\"", `last_name`:"Muhammad", `shoe_size`:13.5})
 create (_34428:`Player` {`age`:27, `birthplace`:"Bijelo Polje, Serbia and Montenegro", `first_name`:"Nikola", `height_formatted`:"6'11\"", `last_name`:"Pekovic", `shoe_size`:15.5})
 create (_34429:`Player` {`age`:27, `birthplace`:"Orange, New Jersey, USA", `first_name`:"A.J.", `height_formatted`:"6'2\"", `last_name`:"Price", `shoe_size`:10.5})
 create (_34430:`Player` {`age`:23, `birthplace`:"Barcelona, Spain", `first_name`:"Ricky", `height_formatted`:"6'4\"", `last_name`:"Rubio", `shoe_size`:12.5})
 create (_34431:`Player` {`age`:24, `birthplace`:"Belgorod, Russian Federation", `first_name`:"Alexey", `height_formatted`:"6'6\"", `last_name`:"Shved", `shoe_size`:12.5})
 create (_34432:`Player` {`age`:30, `birthplace`:"Le Robert, Martinique", `first_name`:"Ronny", `height_formatted`:"6'10\"", `last_name`:"Turiaf", `shoe_size`:14})
 create (_34433:`Team` {`abbreviation`:"NO", `city`:"New Orleans", `full_name`:"New Orleans Pelicans"})
 create (_34434:`Player` {`age`:23, `birthplace`:"Atlanta, Georgia, USA", `first_name`:"Al-Farouq", `height_formatted`:"6'9\"", `last_name`:"Aminu", `shoe_size`:15})
 create (_34435:`Player` {`age`:31, `birthplace`:"Ventura, California, USA", `first_name`:"Louis", `height_formatted`:"6'9\"", `last_name`:"Amundson", `shoe_size`:16.5})
 create (_34436:`Player` {`age`:25, `birthplace`:"Sacramento, California, USA", `first_name`:"Ryan", `height_formatted`:"6'10\"", `last_name`:"Anderson", `shoe_size`:17.5})
 create (_34437:`Player` {`age`:20, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Anthony", `height_formatted`:"6'10\"", `last_name`:"Davis", `shoe_size`:17})
 create (_34438:`Player` {`age`:24, `birthplace`:"Chester, Pennsylvania, USA", `first_name`:"Tyreke", `height_formatted`:"6'6\"", `last_name`:"Evans", `shoe_size`:15})
 create (_34439:`Player` {`age`:24, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"Eric", `height_formatted`:"6'3\"", `last_name`:"Gordon", `shoe_size`:13.5})
 create (_34440:`Player`:`AllStar` {`age`:23, `birthplace`:"Chatsworth, California, USA", `first_name`:"Jrue", `height_formatted`:"6'3\"", `last_name`:"Holiday", `shoe_size`:13})
 create (_34441:`Player` {`age`:23, `birthplace`:"Maysville, Kentucky, USA", `first_name`:"Darius", `height_formatted`:"6'8\"", `last_name`:"Miller", `shoe_size`:14})
 create (_34442:`Player` {`age`:28, `birthplace`:"Charlotte, North Carolina, USA", `first_name`:"Anthony", `height_formatted`:"6'5\"", `last_name`:"Morrow", `shoe_size`:14})
 create (_34443:`Player` {`age`:21, `birthplace`:"Santa Monica, California, USA", `first_name`:"Austin", `height_formatted`:"6'4\"", `last_name`:"Rivers", `shoe_size`:14})

图的大小

此查询返回图中节点和关系的数量。

match n-[w]-()
with count(distinct n) as numberOfNodes, count(distinct w) as numberOfRelationships
return numberOfNodes, numberOfRelationships;

球员的示例统计数据

此查询返回有关球员的一些统计数据(平均年龄、最小和最大年龄,以及最大和最小身高)。

match (p:Player)
return avg(p.age) as averageAge, min(p.age) as minAge, max(p.age) as maxAge, max(p.height_formatted) as maxHeight, min (p.height_formatted) as minHeight;

使用最多的五大品牌

此查询返回 NBA 球员使用最多的五个品牌的名称。

match (n:Brand)-[*2]-(p:Player)
with n.name as brand, count(distinct p) as numberOfPlayers
return brand, numberOfPlayers
order by numberOfPlayers desc limit 5;

使用最多的五大鞋款

此查询返回使用最多的五个运动鞋的名称。

match (m:Model)-[:WEARS]-(p:Player)
with m.name as model, count(distinct p) as numberOfPlayers
return model, numberOfPlayers
order by numberOfPlayers desc limit 5;

五大最大鞋码

此查询返回鞋码最大的五名球员的姓名。

MATCH (n:Player)
RETURN str(n.first_name + " " + n.last_name) AS player, max(n.shoe_size) AS shoeSize
ORDER BY shoeSize DESC
LIMIT 5

科比、勒布朗和凯文·杜兰特的队友中,有多少人穿着他们签名款球鞋?

此查询返回科比·布莱恩特、勒布朗·詹姆斯和凯文·杜兰特的队友中,有多少人穿着科比、勒布朗或 KD 的签名款球鞋。

match (n:AllStar)-[:PLAYS_FOR]->(t:Team)<-[:PLAYS_FOR]-(x:Player)-[:WEARS]->(m:Model)
where (n.first_name ="Kobe" and m.name=~".*Kobe.*")
or (n.first_name="LeBron" and m.name=~".*LeBron.*")
or (n.first_name="Kevin" and n.last_name="Durant" and m.name=~".*KD.*")
return distinct n.last_name as name, count (DISTINCT x.last_name) as numberOfTeammates;

来自康普顿的球员都穿什么运动鞋?

此查询返回来自康普顿的球员的姓名以及他们所穿的运动鞋。

match (n:Player)-[w:WEARS]-(m:Model)
where n.birthplace=~".*Compton.*"
return str(n.first_name + " " + n.last_name) as player, collect(m.name) as sneakers;

为家乡球队效力的球员都穿什么运动鞋?

此查询返回为家乡球队效力的球员的姓名以及他们的运动鞋。

match (t:Team)<-[:PLAYS_FOR]-(n:Player)-[w:WEARS]-(m:Model)
where t.city= substring(n.birthplace, 0, length(t.city))
return str(n.first_name + " " + n.last_name) as player, t.full_name as teamName, collect(m.name) as sneakers;

哪些鞋款只被七尺以上的球员穿着?

此查询返回只被身高七英尺或以上的球员穿着的运动鞋的名称。

match (player:Player)-[:WEARS]->(model:Model)-[:MADE_BY]->(brand:Brand)
with model as model, brand as brand, collect(player) as players
where all(x in players where x.height_formatted =~ "7.*")
return brand.name as brandName, model.name as modelName, extract(player in players| str(player.first_name + " " + player.last_name)) as playerName
order by brandName;

新秀的平均鞋码是多少?

此查询返回新秀的平均鞋码。

MATCH (p:Player:Rookie) return avg(p.shoe_size) as averageRookiesShoeSize

哪些球员不穿品牌运动鞋?

此查询返回不穿品牌运动鞋的球员的姓名。

match (p:Player) where not (p-[:WEARS]->()) return str(p.first_name + " " + p.last_name) as playerWithoutBrandNameSneakers

哪些球员穿超过一种运动鞋型号?

此查询返回穿超过一种运动鞋型号的球员的姓名、他们穿的型号数量以及型号名称。

match (p:Player)-[:WEARS]->(m:Model)
with collect(m) as models, p as p
where reduce(count = 0, model in models | count +1) > 1
return p.first_name as name, p.last_name as surname, reduce(count = 0, model in models | count +1) as numberOfModels, extract(m in models| m.name) as sneakers
order by numberOfModels desc;

所有运动鞋的成本

此查询为所有运动鞋设置随机价格,并返回其总成本。

MATCH (m:Model)
SET m.price=RAND()*30+50
RETURN reduce(total_amount = 0, x IN collect(m) | total_amount + x.price) as costOfAllSneakers

随机抽签成本价格彩票

此查询返回所有运动鞋的价格。价格是随机的。

match (m:Model)
return m.name as name, m.price as price
order by m.price desc;

关于我们

我们的名字是路易斯·安赫尔和塞尔吉奥·G。我们在奥维耶多大学学习软件工程。我们得到了用 Neo4j 做一些工作的任务,并且我们已经完成了。我们希望您像我们开发它一样享受这个片段。