Migrate from SQL to APL

| <DatasetName>
| <FilteringOperation> 
| <ProjectionOperation> 
| <AggregationOperation>

SELECT *
FROM [Sample-http-logs]
WHERE method = 'GET';

['sample-http-logs']
| where method == 'GET'

SELECT Country, COUNT(*)
FROM [Sample-http-logs]
GROUP BY method;

['sample-http-logs']
| summarize count() by method

SELECT TOP 10 Status, Method
FROM [Sample-http-logs]
ORDER BY Method DESC;

['sample-http-logs']
| top 10 by method desc
| project status, method

SELECT method, status, geo.country
FROM [Sample-http-logs]
WHERE resp_header_size_bytes >= 18;

['sample-http-logs']
| where resp_header_size_bytes >= 18
| project method, status, ['geo.country']

SELECT geo.country
FROM [Sample-http-logs]
GROUP BY geo.country
HAVING COUNT(*) > 100;

['sample-http-logs']
| summarize count() by ['geo.country']
| where count_ > 100

SELECT geo.country,
       COUNT(*) AS TotalRequests,
       AVG(req_duration_ms) AS AverageRequest,
       MIN(req_duration_ms) AS MinRequest,
       MAX(req_duration_ms) AS MaxRequest
FROM [Sample-http-logs]
GROUP BY geo.country;

Users
| summarize TotalRequests = count(),
            AverageRequest = avg(req_duration_ms),
            MinRequest = min(req_duration_ms),
            MaxRequest = max(req_duration_ms) by ['geo.country']

SELECT SUM(resp_body_size_bytes) AS TotalBytes
FROM  [Sample-http-logs];

[‘sample-http-logs’]
| summarize TotalBytes = sum(resp_body_size_bytes)

SELECT AVG(req_duration_ms) AS AverageRequest
FROM [Sample-http-logs];

['sample-http-logs']
| summarize AverageRequest = avg(req_duration_ms)

SELECT MIN(req_duration_ms) AS MinRequest, MAX(req_duration_ms) AS MaxRequest
FROM [Sample-http-logs];

['sample-http-logs']
| summarize MinRequest = min(req_duration_ms), MaxRequest = max(req_duration_ms)

SELECT COUNT(DISTINCT method) AS UniqueMethods
FROM [Sample-http-logs];

['sample-http-logs']
| summarize UniqueMethods = dcount(method)

SELECT STDDEV(req_duration_ms) AS StdDevRequest
FROM  [Sample-http-logs];

['sample-http-logs']
| summarize StdDevRequest = stdev(req_duration_ms)

SELECT VAR(req_duration_ms) AS VarRequest
FROM  [Sample-http-logs];

['sample-http-logs']
| summarize VarRequest = variance(req_duration_ms)

SELECT COUNT(*) AS TotalDuration, SUM(req_duration_ms) AS TotalDuration, AVG(Price) AS AverageDuration
FROM  [Sample-http-logs];

['sample-http-logs']
| summarize TotalOrders = count(), TotalDuration = sum( req_duration_ms), AverageDuration = avg(req_duration_ms)

SELECT status, COUNT(*) AS TotalStatus, SUM(resp_header_size_bytes) AS TotalRequest
FROM [Sample-http-logs];
GROUP BY status
ORDER BY TotalSpent DESC;

['sample-http-logs']
| summarize TotalStatus = count(), TotalRequest = sum(resp_header_size_bytes) by status
| order by TotalRequest desc

SELECT COUNT(*) AS HighContentStatus
FROM  [Sample-http-logs];
WHERE resp_header_size_bytes  > 1;

['sample-http-logs']
| where resp_header_size_bytes > 1
| summarize HighContentStatus = count()

SELECT Status
FROM [Sample-http-logs];
GROUP BY Status
HAVING COUNT(*) > 10;

['sample-http-logs']
| summarize OrderCount = count() by status
| where OrderCount > 10

SELECT content_type, COUNT(*) AS RequestCount
FROM  [Sample-http-logs];
WHERE content_type = ‘text/csv’;

 ['sample-http-logs'];
| where content_type == 'text/csv'
| summarize RequestCount = count()

SELECT LEN(Status) AS NameLength
FROM [Sample-http-logs];

['sample-http-logs']
| extend NameLength = strlen(status)

SELECT CONCAT(content_type, ' ', method) AS FullLength
FROM [Sample-http-logs];

['sample-http-logs']
| extend FullLength = strcat(content_type, ' ', method)

SELECT SUBSTRING(content_type, 1, 10) AS ShortDescription
FROM [Sample-http-logs];

['sample-http-logs']
| extend ShortDescription = substring(content_type, 0, 10)

SELECT LEFT(content_type, 3) AS LeftTitle, RIGHT(content_type, 3) AS RightTitle
FROM [Sample-http-logs];

['sample-http-logs']
| extend LeftTitle = substring(content_type, 0, 3), RightTitle = substring(content_type, strlen(content_type) - 3, 3)

SELECT REPLACE(StaTUS, 'old', 'new') AS UpdatedStatus
FROM [Sample-http-logs];

['sample-http-logs']
| extend UpdatedStatus = replace('old', 'new', status)

SELECT UPPER(FirstName) AS UpperFirstName, LOWER(LastName) AS LowerLastName
FROM [Sample-http-logs];

['sample-http-logs']
| project upperFirstName = toupper(content_type), LowerLastNmae = tolower(status)

SELECT LTRIM(content_type) AS LeftTrimmedFirstName, RTRIM(content_type) AS RightTrimmedLastName
FROM  [Sample-http-logs];

['sample-http-logs']
| extend LeftTrimmedFirstName = trim_start(' ', content_type), RightTrimmedLastName = trim_end(' ', content_type)

SELECT TRIM(content_type) AS TrimmedFirstName
FROM [Sample-http-logs];

['sample-http-logs']
| extend TrimmedFirstName = trim(' ', content_type)

SELECT REVERSE(Method) AS ReversedFirstName
FROM [Sample-http-logs];

['sample-http-logs']
| extend ReversedFirstName = reverse(method)

SELECT Status, Method
FROM “Sample-http-logs”
WHERE LOWER(Method) LIKE 'get’';

['sample-http-logs']
| where tolower(method) contains 'GET'
| project status, method