Jump to content

mrchow19910319

Member
  • Content count

    3,015
  • Joined

  • Last visited

Awards


This user doesn't have any awards

About mrchow19910319

  • Title
    Locked i7 FTW. PC money > lunch money.
  • Birthday 1991-03-19

Contact Methods

Profile Information

  • Gender
    Male
  • Interests
    PC gaming, reading (mostly novels), programming, shit-posting, loving apple hardware and software

System

  • CPU
    i7 8700
  • Motherboard
    AsRock mini itx ac.
  • RAM
    8GB
  • GPU
    EVGA GTX 1060 single fan edition. (this thing is a beast!)
  • Case
    Fractal Design Node 304 white edition
  • Storage
    120GB of SSD 1TB of HDD
  • PSU
    Corsair SF450
  • Display(s)
    Dell P2416D
  • Keyboard
    K70 brown switches
  • Mouse
    SteelSeries Rival 310 (compares to my last mouse Sensei this mouse feels really cheap. but the sensor in it is better)
  • Sound
    Logitech UE mini
  • Operating System
    windows 10

Recent Profile Visitors

11,547 profile views
  1. SQL sub querry question

    I will take a look at this tmr... too tired just got off from work and learned a bit about SQL for 2 hours. I will give you a reply tomorrow. also I am following this tutorial, what do you tthink about it? do you think that it is good for a beginner? https://www.khanacademy.org/computing/computer-programming/sql
  2. SQL sub querry question

    okay.. I only know: WHERE IN SELECT INSERT syntax... care to explain???
  3. SQL sub querry question

    /*add another query that will select the title of all the songs from the 'Pop' artists. It should use IN on a nested subquery that's based on your previous query.*/
  4. SQL sub querry question

    CREATE TABLE artists ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, country TEXT, genre TEXT); INSERT INTO artists (name, country, genre) VALUES ("Taylor Swift", "US", "Pop"); INSERT INTO artists (name, country, genre) VALUES ("Led Zeppelin", "US", "Hard rock"); INSERT INTO artists (name, country, genre) VALUES ("ABBA", "Sweden", "Disco"); INSERT INTO artists (name, country, genre) VALUES ("Queen", "UK", "Rock"); INSERT INTO artists (name, country, genre) VALUES ("Celine Dion", "Canada", "Pop"); INSERT INTO artists (name, country, genre) VALUES ("Meatloaf", "US", "Hard rock"); INSERT INTO artists (name, country, genre) VALUES ("Garth Brooks", "US", "Country"); INSERT INTO artists (name, country, genre) VALUES ("Shania Twain", "Canada", "Country"); INSERT INTO artists (name, country, genre) VALUES ("Rihanna", "US", "Pop"); INSERT INTO artists (name, country, genre) VALUES ("Guns N' Roses", "US", "Hard rock"); INSERT INTO artists (name, country, genre) VALUES ("Gloria Estefan", "US", "Pop"); INSERT INTO artists (name, country, genre) VALUES ("Bob Marley", "Jamaica", "Reggae"); CREATE TABLE songs ( id INTEGER PRIMARY KEY AUTOINCREMENT, artist TEXT, title TEXT); INSERT INTO songs (artist, title) VALUES ("Taylor Swift", "Shake it off"); INSERT INTO songs (artist, title) VALUES ("Rihanna", "Stay"); INSERT INTO songs (artist, title) VALUES ("Celine Dion", "My heart will go on"); INSERT INTO songs (artist, title) VALUES ("Celine Dion", "A new day has come"); INSERT INTO songs (artist, title) VALUES ("Shania Twain", "Party for two"); INSERT INTO songs (artist, title) VALUES ("Gloria Estefan", "Conga"); INSERT INTO songs (artist, title) VALUES ("Led Zeppelin", "Stairway to heaven"); INSERT INTO songs (artist, title) VALUES ("ABBA", "Mamma mia"); INSERT INTO songs (artist, title) VALUES ("Queen", "Bicycle Race"); INSERT INTO songs (artist, title) VALUES ("Queen", "Bohemian Rhapsody"); INSERT INTO songs (artist, title) VALUES ("Guns N' Roses", "Don't cry"); SELECT title FROM songs WHERE artist = "Queen"; SELECT name FROM artists WHERE genre = "Pop"; /*add another query that will select the title of all the songs from the 'Pop' artists. It should use IN on a nested subquery that's based on your previous query.*/ /*select title from songs where genre in artists = "Pop"*/ SELECT title FROM songs WHERE name IN (SELECT name FROM artists WHERE genre = "Pop"); I have no idea how to do this. Someone help/??
  5. how long do I have to wait until I can watch sicario 2 on youtube..........  

     

  6. Massive Apple refresh maybe on the way

    mine's better :
  7. Massive Apple refresh maybe on the way

    macOS in some way is more pleasant to use than windows. especially when it comes to normal day to day task.
  8. 65% mech keyboard recommendation.

    thanks!
  9. 65% mech keyboard recommendation.

    yeah.. just found out the channel and think you will like it.
  10. 65% mech keyboard recommendation.

    it looks shiny.. lol
  11. 65% mech keyboard recommendation.

    https://www.youtube.com/channel/UCllGwtW6scxAjM28fIgEozg @geo3
  12. ...deleted my own comment..
  13. This is getting confusing now, leaked benchmarks of the GTX2080TI appear

    who's gonna purchase a new GPU everyyear.... I dont think that many people care.
  14. yeah... not like those 32GB of ram on macbook pros are gonna use themselves..
×