This form gives you a chance to modify the query and quickly see the results but it does not update the wiki page..

  <query>
    SELECT
      command_name AS "Command Name",
      num_commands * 100.0 / total_num_commands AS "%"
    FROM
     (SELECT
        command_name,
        COUNT(command_name) AS num_commands
      FROM
        native_command_events,
        command_names
      WHERE
        native_command_events.command_id = command_names.command_id AND
        native_command_events.log_num IN (SELECT log_num FROM significant_logs)
      GROUP BY
        command_names.command_name
      ) AS raw_command_counts,
     (SELECT
        COUNT(command_id) AS total_num_commands
      FROM
        native_command_events
      WHERE
        native_command_events.log_num IN (SELECT log_num FROM significant_logs)
      ) AS total_command_counts
    ORDER BY
      command_name
  </query>
  <view type="table" caption="Raw Command Counts Over All Logs"/>

This form gives you a chance to modify the query and quickly see the results but it does not update the wiki page..

  <query>
    SELECT
      command_name AS "Command Name",
      num_command_instances AS "Number of Sightings",
      num_command_instances * 100.0 / total_instances_count AS "%"
    FROM
      (SELECT
         command_name,
         COUNT(command_name) AS num_command_instances
       FROM
        (SELECT
           DISTINCT native_command_events.log_num,
           command_name
         FROM
           native_command_events,
           command_names
         WHERE
           native_command_events.command_id = command_names.command_id AND
           native_command_events.log_num IN (SELECT log_num FROM significant_logs)
         GROUP BY
           native_command_events.log_num,
           command_names.command_name
         ) AS command_per_session_table
       GROUP BY
         command_name
      ) AS command_instances_over_logs_table,
      (SELECT
         COUNT(command_name) AS total_instances_count
       FROM
        (SELECT
           DISTINCT native_command_events.log_num,
           command_name
         FROM
           native_command_events,
           command_names
         WHERE
           native_command_events.command_id = command_names.command_id AND
           native_command_events.log_num IN (SELECT log_num FROM significant_logs)
         GROUP BY
           native_command_events.log_num,
           command_names.command_name
         ) AS command_per_session_table
       ) AS total_command_count_table
    ORDER BY
      "%" DESC
  </query>
  <view type="table" caption="Command Sightings Across All Logs, Ordered by Frequency"/>

This form gives you a chance to modify the query and quickly see the results but it does not update the wiki page..

  <query>
    SELECT
      command_name AS "Command Name",
      num_command_instances AS "Number of Users Using Command",
      num_command_instances * 100.0 / num_sig_users AS "% Users"
    FROM
      (SELECT
         command_name,
         COUNT(command_name) AS num_command_instances
       FROM
        (SELECT
           DISTINCT user_id,
           command_name
         FROM
           interaction_log,
           native_command_events,
           command_names
         WHERE
           interaction_log.log_num = native_command_events.log_num AND
           native_command_events.command_id = command_names.command_id AND
           native_command_events.log_num IN (SELECT log_num FROM significant_logs)
         GROUP BY
           user_id,
           command_names.command_name
         ) AS command_per_session_table
       GROUP BY
         command_name
      ) AS command_instances_over_logs_table,
      (SELECT
         COUNT(user_id) AS num_sig_users
       FROM
         significant_users
       ) AS sig_users_table
    ORDER BY
      "% Users" DESC
  </query>
  <view type="table" caption="Percent Users Who Have Used Each Command, Sorted by Frequency"/>

This form gives you a chance to modify the query and quickly see the results but it does not update the wiki page..

  <query>
    SELECT
      command_name AS "Command Name",
      ROUND(AVG(num_uses)) AS "Mean Per Log",
      ROUND(MEDIAN(num_uses)) AS "Median Per Log",
      ROUND(STDDEV(num_uses)) AS "SD Per Log",
      COUNT(num_uses) AS "n"
    FROM
      (SELECT
         native_command_events.log_num,
         command_name,
         COUNT(command_name) AS num_uses
       FROM
         native_command_events,
         command_names
       WHERE
         native_command_events.command_id = command_names.command_id AND
         native_command_events.log_num IN (SELECT log_num FROM significant_logs)
       GROUP BY
         native_command_events.log_num,
         command_name
       ) AS commands_per_session_table
    GROUP BY
      command_name
    ORDER BY
      "Mean Per Log" DESC
  </query>
  <view type="table" caption="Summary Stats for Number of Uses Per Session, Ordered by Mean Frequency"/>

This form gives you a chance to modify the query and quickly see the results but it does not update the wiki page..

  <query>
    SELECT
      command_name AS "Command Name",
      ROUND(AVG(mean_per_user)) AS "Mean Mean Per User",
      ROUND(MEDIAN(mean_per_user)) AS "Median Mean Per User",
      ROUND(STDDEV(mean_per_user)) AS "SD Mean Per User",
      ROUND(AVG(median_per_user)) AS "Mean Median Per User",
      ROUND(MEDIAN(median_per_user)) AS "Median Median Per User",
      ROUND(STDDEV(median_per_user)) AS "SD Median Per User",
      COUNT(mean_per_user) AS "n"
    FROM
     (SELECT
        command_name,
        AVG(num_uses) AS mean_per_user,
        MEDIAN(num_uses) AS median_per_user
      FROM
        interaction_log,
        (SELECT
           native_command_events.log_num,
           command_name,
           COUNT(command_name) AS num_uses
         FROM
           native_command_events,
           command_names
         WHERE
           native_command_events.command_id = command_names.command_id AND
           native_command_events.log_num IN (SELECT log_num FROM significant_logs)
         GROUP BY
           native_command_events.log_num,
           command_name
         ) AS commands_per_session_table
      WHERE
        interaction_log.log_num = commands_per_session_table.log_num
      GROUP BY
        command_name,
        user_id) AS command_summary_per_user
    GROUP BY
      command_name
    ORDER BY
      "Mean Mean Per User" DESC
  </query>
  <view type="table" caption="Summary Stats for Number of Uses Per User Per Session, Ordered by Mean Frequency"/>