sql-querying

  • e1_490466
    了解作者
  • 307.9KB
    文件大小
  • zip
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-05-12 06:47
    上传日期
sql-querying
sql-querying-master.zip
  • sql-querying-master
  • queries_products.sql
    1.9KB
  • seed_products.sql
    226B
  • seed_playstore.sql
    1.3MB
  • queries_playstore.sql
    2.8KB
  • further_study.sql
    693B
内容介绍
-- from the terminal run: -- psql < seed.sql DROP DATABASE IF EXISTS playstore; CREATE DATABASE playstore; \c playstore CREATE TABLE analytics ( id SERIAL PRIMARY KEY, app_name TEXT NOT NULL, category TEXT NOT NULL, rating FLOAT(1), reviews INT, size TEXT, min_installs INT, price FLOAT(2), content_rating TEXT, genres TEXT[], last_updated DATE, current_version TEXT, android_version TEXT ); INSERT INTO analytics (app_name, category, rating, reviews, size, min_installs, price, content_rating, genres, last_updated, current_version, android_version) VALUES ('Facebook', 'SOCIAL', 4.1, 78158306, 'Varies with device', 1000000000, 0, 'Teen', '{"Social"}', '2018-08-03', 'Varies with device', 'Varies with device'), ('WhatsApp Messenger', 'SOCIAL', 4.1, 78128208, 'Varies with device', 1000000000, 0, 'Teen', '{"Social"}', '2018-08-03', 'Varies with device', 'Varies with device'), ('Instagram', 'COMMUNICATION', 4.4, 69119316, 'Varies with device', 1000000000, 0, 'Everyone', '{"Communication"}', '2018-08-03', 'Varies with device', 'Varies with device'), ('Messenger – Text and Video Chat for Free', 'COMMUNICATION', 4.4, 69119316, 'Varies with device', 1000000000, 0, 'Everyone', '{"Communication"}', '2018-08-03', 'Varies with device', 'Varies with device'), ('Clash of Clans', 'COMMUNICATION', 4.4, 69109672, 'Varies with device', 1000000000, 0, 'Everyone', '{"Communication"}', '2018-08-03', 'Varies with device', 'Varies with device'), ('Clean Master- Space Cleaner & Antivirus', 'SOCIAL', 4.5, 66577446, 'Varies with device', 1000000000, 0, 'Teen', '{"Social"}', '2018-07-31', 'Varies with device', 'Varies with device'), ('Subway Surfers', 'SOCIAL', 4.5, 66577313, 'Varies with device', 1000000000, 0, 'Teen', '{"Social"}', '2018-07-31', 'Varies with device', 'Varies with device'), ('YouTube', 'SOCIAL', 4.5, 66577313, 'Varies with device', 1000000000, 0, 'Teen', '{"Social"}', '2018-07-31', 'Varies with device', 'Varies with device'), ('Security Master - Antivirus, VPN, AppLock, Booster', 'SOCIAL', 4.5, 66509917, 'Varies with device', 1000000000, 0, 'Teen', '{"Social"}', '2018-07-31', 'Varies with device', 'Varies with device'), ('Clash Royale', 'COMMUNICATION', 4, 56646578, 'Varies with device', 1000000000, 0, 'Everyone', '{"Communication"}', '2018-08-01', 'Varies with device', 'Varies with device'), ('Candy Crush Saga', 'COMMUNICATION', 4, 56642847, 'Varies with device', 1000000000, 0, 'Everyone', '{"Communication"}', '2018-08-01', 'Varies with device', 'Varies with device'), ('UC Browser - Fast Download Private & Secure', 'COMMUNICATION', 4, 56642847, 'Varies with device', 1000000000, 0, 'Everyone', '{"Communication"}', '2018-08-01', 'Varies with device', 'Varies with device'), ('Snapchat', 'GAME', 4.6, 44893888, '98M', 100000000, 0, 'Everyone 10+', '{"Strategy"}', '2018-07-15', '10.322.16', '4.1 and up'), ('360 Security - Free Antivirus, Booster, Cleaner', 'GAME', 4.6, 44891723, '98M', 100000000, 0, 'Everyone 10+', '{"Strategy"}', '2018-07-15', '10.322.16', '4.1 and up'), ('My Talking Tom', 'GAME', 4.6, 44891723, '98M', 100000000, 0, 'Everyone 10+', '{"Strategy"}', '2018-07-15', '10.322.16', '4.1 and up'), ('8 Ball Pool', 'FAMILY', 4.6, 44881447, '98M', 100000000, 0, 'Everyone 10+', '{"Strategy"}', '2018-07-15', '10.322.16', '4.1 and up'), ('DU Battery Saver - Battery Charger & Battery Life', 'TOOLS', 4.7, 42916526, 'Varies with device', 500000000, 0, 'Everyone', '{"Tools"}', '2018-08-03', 'Varies with device', 'Varies with device'), ('BBM - Free Calls & Messages', 'GAME', 4.5, 27725352, '76M', 1000000000, 0, 'Everyone 10+', '{"Arcade"}', '2018-07-12', '1.90.0', '4.1 and up'), ('Cache Cleaner-DU Speed Booster (booster & cleaner)', 'GAME', 4.5, 27725352, '76M', 1000000000, 0, 'Everyone 10+', '{"Arcade"}', '2018-07-12', '1.90.0', '4.1 and up'), ('Twitter', 'GAME', 4.5, 27724094, '76M', 1000000000, 0, 'Everyone 10+', '{"Arcade"}', '2018-07-12', '1.90.0', '4.1 and up'), ('Viber Messenger', 'GAME', 4.5, 27723193, '76M', 1000000000, 0, 'Everyone 10+', '{"Arcade"}', '2018-07-12', '1.90.0', '4.1 and up'), ('Shadow Fight 2', 'GAME', 4.5, 27722264, '76M', 1000000000, 0, 'Everyone 10+', '{"Arcade"}', '2018-07-12', '1.90.0', '4.1 and up'), ('Google Photos', 'GAME', 4.5, 27711703, '76M', 1000000000, 0, 'Everyone 10+', '{"Arcade"}', '2018-07-12', '1.90.0', '4.1 and up'), ('LINE: Free Calls & Messages', 'VIDEO_PLAYERS', 4.3, 25655305, 'Varies with device', 1000000000, 0, 'Teen', '{"Video Players & Editors"}', '2018-08-02', 'Varies with device', 'Varies with device'), ('Pou', 'VIDEO_PLAYERS', 4.3, 25623548, 'Varies with device', 1000000000, 0, 'Teen', '{"Video Players & Editors"}', '2018-08-02', 'Varies with device', 'Varies with device'), ('Skype - free IM & video calls', 'TOOLS', 4.7, 24900999, 'Varies with device', 500000000, 0, 'Everyone', '{"Tools"}', '2018-08-04', '4.6.6', 'Varies with device'), ('Pokémon GO', 'GAME', 4.6, 23136735, '97M', 100000000, 0, 'Everyone 10+', '{"Strategy"}', '2018-06-27', '2.3.2', '4.1 and up'), ('Minion Rush: Despicable Me Official Game', 'GAME', 4.6, 23134775, '97M', 100000000, 0, 'Everyone 10+', '{"Strategy"}', '2018-06-27', '2.3.2', '4.1 and up'), ('Yes day', 'GAME', 4.6, 23133508, '97M', 100000000, 0, 'Everyone 10+', '{"Strategy"}', '2018-06-27', '2.3.2', '4.1 and up'), ('Hay Day', 'FAMILY', 4.6, 23125280, '97M', 100000000, 0, 'Everyone 10+', '{"Strategy"}', '2018-06-27', '2.3.2', '4.1 and up'), ('Dream League Soccer 2018', 'GAME', 4.4, 22430188, '74M', 500000000, 0, 'Everyone', '{"Casual"}', '2018-07-05', '1.129.0.2', '4.1 and up'), ('My Talking Angela', 'GAME', 4.4, 22430188, '74M', 500000000, 0, 'Everyone', '{"Casual"}', '2018-07-05', '1.129.0.2', '4.1 and up'), ('VivaVideo - Video Editor & Photo Movie', 'GAME', 4.4, 22429716, '74M', 500000000, 0, 'Everyone', '{"Casual"}', '2018-07-05', '1.129.0.2', '4.1 and up'), ('Google Chrome: Fast & Secure', 'GAME', 4.4, 22428456, '74M', 500000000, 0, 'Everyone', '{"Casual"}', '2018-07-05', '1.129.0.2', '4.1 and up'), ('Maps - Navigate & Explore', 'GAME', 4.4, 22428456, '74M', 500000000, 0, 'Everyone', '{"Casual"}', '2018-07-05', '1.129.0.2', '4.1 and up'), ('Hill Climb Racing', 'GAME', 4.4, 22426677, '74M', 500000000, 0, 'Everyone', '{"Casual"}', '2018-07-05', '1.129.0.2', '4.1 and up'), ('Facebook Lite', 'FAMILY', 4.4, 22419455, '74M', 500000000, 0, 'Everyone', '{"Casual"}', '2018-07-05', '1.129.0.2', '4.1 and up'), ('Asphalt 8: Airborne', 'COMMUNICATION', 4.5, 17714850, '40M', 500000000, 0, 'Teen', '{"Communication"}', '2018-08-02', '12.8.5.1121', '4.0 and up'), ('Mobile Legends: Bang Bang', 'COMMUNICATION', 4.5, 17712922, '40M', 500000000, 0, 'Teen', '{"Communication"}', '2018-08-02', '12.8.5.1121', '4.0 and up'), ('Battery Doctor-Battery Life Saver & Battery Cooler', 'COMMUNICATION', 4.5, 17712922, '40M', 500000000, 0, 'Teen', '{"Communication"}', '2018-08-02', '12.8.5.1121', '4.0 and up'), ('Temple Run 2', 'SOCIAL', 4, 17015352, 'Varies with device', 500000000, 0, 'Teen', '{"Social"}', '2018-07-30', 'Varies with device', 'Varies with device'), ('Piano Tiles 2™', 'SOCIAL', 4, 17014787, 'Varies with device', 500000000, 0, 'Teen', '{"Social"}', '2018-07-30', 'Varies with device', 'Varies with device'), ('Google', 'SOCIAL', 4, 17014705, 'Varies with device', 500000000, 0, 'Teen', '{"Social"}', '2018-07-30', 'Varies with device', 'Varies with device'), ('Truecaller: Caller ID, SMS spam blocking & Dialer', 'SOCIAL', 4, 17000166, 'Varies with device', 500000000, 0, 'Teen', '{"Social"}', '2018-07-30', 'Varies with device', 'Varies with device'), ('SHAREit - Transfer & Share', 'TOOLS', 4.6, 16771865, 'Varies with device', 100000000, 0, 'Everyone', '{"Tools"}', '2018-08-04', 'Varies with device', 'Varies with device'), ('Sniper 3D Gun Shooter: Free Shooting Games - FPS', 'GAME', 4.5, 14892469, 'Varies with device', 500000000, 0, 'Everyone', '{"Casual"}', '2018-07-19', '4.8.0.132', '4.1 and up'), ('Farm Heroes Saga', 'GAME', 4.5, 14891223, 'Varies with device', 5000
评论
    相关推荐
    • sql
      sql 在edX上参加IBM数据科学SQL课程时编译了一些ipython笔记本和sql脚本( )
    • sql
      sql主要sql来自: :
    • SQL Monitor
      SQL Monitor 是一款界面简洁、绿色小巧的sql活动监视器,它能够帮助用户对 SQL Server 运行进程和Job进行实时监视,您可以查看当前执行的SQL/命令并终止。
    • SQL 语言
      SQL语言基础 SQL语法介绍 ppt
    • sql search
      非常好用的sql server 搜索工具。sql search sql search
    • Sql Prompt
      SQLPromptBundle.zip 中的sqlprompt3setup.exe 为安装文件。 压缩包解压开之后,执行Initialize.bat即可。
    • sqlexplorer
      sql2000数据加密查看工具sql2000数据加密查看工具sql2000数据加密查看工具sql2000数据加密查看工具
    • sql sql sql
      sql学习 sql sql sql sql sql sql sql
    • ConnectSQL
      VC连接SQL VC连接SQL VC连接SQL VC连接SQL VC连接SQL VC连接SQL VC连接SQL VC连接SQL
    • SQL学习
      关于SQL一些的资料总结,我也是从网上找的 谢谢了 是TXT格式的