Database

data modeling guy wrote:

Hello- can you give me any example
scenarios/questions for writing a complex SELECT statements? My intention is to
improve my SQL skills.

• Calculate reputation points of a user.
  
• Fetch the contibutions-section for a user (see the section on your user-page; it contains some statistics)
  
• Fetch the ten members from the database that answered most questions last month.
  
• Fetch the voting-percentages for the straw-poll result for all possible answers.
  
• Fetch any low-repuation member that posts the same message in multiple places, ordered by the amount of similar messages.
  
• Fetch the data to show the forum-content for page 3 of this forum, in threaded view, with 50 posts per page.
  

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Miller Nguyen wrote:

In Excel, it should be

For example, -0.5 and 0.5 both mean noon on 30 December 1899

DELIMITER $$

DROP PROCEDURE IF EXISTS CleanCopyEnvData$$

CREATE PROCEDURE CleanCopyEnvData ()
BEGIN

  insert into  EnvData(UserDate, XAction, Balance, UserID)
  select
    CAST(udate as Date)
    , CAST(amount1 as Decimal(6,3))
    , CAST(amount2 as Decimal(6,3))
    , CAST(UID as UnSigned)
  from
    DataLoad;

END