DROP TABLE IF EXISTS
     #rndt;
CREATE TABLE #rndt
(g1     INT
, g2     INT
, g3     INT
, amount DECIMAL(10, 2)
);
DECLARE @cntr1 INT, @cntr2 INT, @cntr3 INT, @cntr4 INT, @cntr1ub INT, @cntr2ub INT, @cntr3ub INT, @cntr4ub INT, @r1 INT, @r2 INT, @r3 INT;
SET @cntr1 = 0;
WHILE @cntr1 < 100
    BEGIN
        SET @cntr1 = @cntr1 + 1;
        SET @r1 = ROUND(RAND() * 10000, 0);
        SET @cntr2 = 0;
        SET @cntr2ub = ROUND(RAND() * 10, 0) + 1;
        WHILE @cntr2 < @cntr2ub
            BEGIN
                SET @cntr2 = @cntr2 + 1;
                SET @r2 = ROUND(RAND() * 10000, 0);
                SET @cntr3 = 0;
                SET @cntr3ub = ROUND(RAND() * 10, 0) + 1;
                WHILE @cntr3 < @cntr3ub
                    BEGIN
                        SET @cntr3 = @cntr3 + 1;
                        SET @r3 = ROUND(RAND() * 10000, 0);
                        SET @cntr4 = 0;
                        SET @cntr4ub = ROUND(RAND() * 10, 0) + 1;
                        WHILE @cntr4 < @cntr4ub
                            BEGIN
                                SET @cntr4 = @cntr4 + 1;
                                INSERT INTO #rndt
                                       SELECT
                                              @r1
                                            , @r2
                                            , @r3
                                            , ROUND(RAND() * 100000, 2);
                            END;
                    END;
            END;
    END;
SELECT
       g1
     , g2
     , g3
     , amount
FROM   #rndt
ORDER BY
         amount DESC;
DROP TABLE IF EXISTS
     #rndt;