creating table from table

hi, i'm trying to create a new table for the following query but it seems that there always seem to be a syntax error near the keyword AS from the first line. Is this the correct way to create a table from another table?

CREATE TABLE max_login AS
DECLARE @freq int
SELECT TOP 1 login_user_id, COUNT(login_user_id) AS freq
FROM track_e_login
WHERE login_user_id != 0
GROUP BY login_user_id
ORDER BY freq DESC

Many thanks!

Hi. thanks for ur help.

Hope someone can help me with this too or rather ans my question for this. I obtained the below table in black font with this SQL. But the result which i need is the max(access), access and course for each id as shown in red.

1)Can I do this using 1 select statement as shown below or do I need to use 2 select statements?


DECLARE @access int
SELECT access_user_id, COUNT(*) AS access, access_cours_code
FROM track_e_access
WHERE access_user_id != 0
GROUP BY access_user_id, access_cours_code
ORDER BY access_user_id, access DESC


id freq course
1 21 PHY101
1 13 PHY102
1 6 PHY103
1 1 PHY104
6 1 AMAT103
7 5 CHEM101
9 11 CHEM101
9 6 PHY101
9 1 AMAT103
11 9 ENG102
19 1 CHIN101

What i need:
id freq course
1 21 PHY101
6 1 AMAT103
7 5 CHEM101
9 11 CHEM101
11 9 ENG102
19 1 CHIN101