Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: Help with SQL Queries

    I think i got it. 

    Can someone please double check?


    SELECT d.date_, SUM(w.workout_hours) AS Total_Workout_High, SUM(w.workout_hours) AS Total_Workout_Low
        FROM workout_table w
    JOIN
    athlete_table a ON...

  • RE: Help with SQL Queries

    Can anyone help with this question please?:

    Create a table to show the aggregate workout hours for each “Hard” and “Basic” level of workout endurance by day:

  • RE: Help with SQL Queries

    Thom A - Thursday, October 25, 2018 4:45 AM

    tempdownloads - Thursday, October 25, 2018 4:40 AM

  • RE: Help with SQL Queries

    Thom A - Thursday, October 25, 2018 4:22 AM

    tempdownloads - Thursday, October 25, 2018 4:04 AM

  • RE: Help with SQL Queries

    I could use some help on question 3 please?

    Here's the code to create the table:

    CREATE TABLE track_table (date_ VARCHAR(4), athleteID VARCHAR(1));

    INSERT...

  • RE: Help with SQL Queries

    John Mitchell-245523 - Thursday, October 25, 2018 2:46 AM

    tempdownloads - Thursday, October 25, 2018 2:39 AM

  • RE: Help with SQL Queries

    If you could help me with question 3 in particular please?

    A distribution of # days active within a week: Create a table to show how many athletes...

  • RE: Help with SQL Queries

    Correct.  I think it's just poorly worded.  Creating tables doesn't make sense.  But are instead SELECT commands.

  • RE: Help with SQL Queries

    Sorry that was my mistake.

    If you could or if anyone else could please assist, that would be greatly appreciated =

Viewing 9 posts - 1 through 9 (of 9 total)