M (Power Query) Code Best Practices Checker

print(f'{sum(int(d)**5 for d in str(n)) == n for n in range(2,200000)}')

SELECT OrderID, COUNT(DISTINCT ProductID) FROM OrderDetails GROUP BY OrderID HAVING COUNT(DISTINCT ProductID) > 1

from itertools import permutations; print([''.join(p) for p in permutations('abc')])

SELECT Employees.LastName, COUNT(Orders.OrderID) AS NumberOfOrders FROM (Orders INNER JOIN Employees ON Orders.EmployeeID = Employees.EmployeeID) GROUP BY LastName

import threading; def foo(bar): print('hello {0}'.format(bar)); threading.Thread(target=foo, args=('world!',)).start()

import asyncio; async def main(): print('Hello'); await asyncio.sleep(1); print('world'); asyncio.run(main())

import random; print(sorted([random.random() for i in range(10)]))

SELECT AVG(Price) FROM Products WHERE CategoryID IN (SELECT CategoryID FROM Categories WHERE CategoryName = 'Dairy Products')

import numpy as np; matrix = np.array([[1, 2, 3], [4, 5, 6], [7, 8, 9]]); ev = np.linalg.eigvals(matrix); print(ev)

SELECT EmployeeID, Max(YEAR(OrderDate) - YEAR(BirthDate)) AS MaxAge FROM Employees INNER JOIN Orders ON Employees.EmployeeID = Orders.EmployeeID GROUP BY EmployeeID