What is the most preferred vehicle make in each state?

Hint: Use the window function RANK() to rank based on the count of customers for each state and vehicle maker.

After ranking, take the vehicle maker whose rank is 1.*/

i want sql code for this statement

"new wheels sales dictionary - Notepad File Edit View New Wheels Data Dictionary shipper_id: Unique ID of the Shipper shipper_name: Name of the Shipper shipper_contact_details: contact detai1 of the Shipper product_id: Unique ID of the Product vehicle_maker: vehicle Manufacturing company name vehicle_model: Vehicle model name vehicle_color: color of the vehicle vehicle_mode7_year: Year of Manufacturing vehicle_price: Price of the vehicle quantity: ordered Quantity customer_id: Unique ID of the customer customer_name: Name of the customer gender: Gender of the customer job_title: Job Title of the customer phone_number: Contact detail of the customer emai1_address: Email address of the customer City: Residing city of the customer country: Residing country of the customer state: Residing state of the customer customer_address: Address of the customer order_date: Date on which customer ordered the vehicle order-id: Unique in of the order ship_date: Shipment Date ship_mode: Shipping Mode/class shipping: Shipping ways posta1_code: Postal code of the customer discount: Discount given to the customer for the particular order by credit card in percentage credit_card_type: Credit Card Type credit_card_number: Credit card number customer_feedback: Feedback of the customer quarter_number : Quarter Number