Database: planet_1
Question: What is the heaviest package sent by the clients which 'John' is part of their name? List package number and weight.
SQL:
SELECT T1.PackageNumber ,  max(T1.Weight) FROM PACKAGE AS T1 JOIN Client AS T2 ON T1.Sender  =  T2.AccountNumber WHERE T2.Name LIKE "John";