Total shipped order items

SQL query for Starshipit

Get the total number of shipped order items.

SELECT COUNT(*) FROM shipped_orderitems

Starshipit data model

Table Unshipped Orders
Dtp: Boolean
Plt: Boolean
Type: String
Items: String
Status: String
Carrier: String
Archived: Boolean
Currency: String
Order_id: Integer
Packages: String
Platform: String
Metadatas: String
Reference: String
Order_date: Date-time
Carrier_name: String
Order_number: String
Add_insurance: Boolean
Create_return: Boolean
Declared_value: Number
Dangerous_goods: Boolean
Insurance_value: Number
Manifest_number: Integer
Destination_city: String
Destination_name: String
Destination_email: String
Destination_phone: String
Destination_state: String
Address_validation: String
Destination_street: String
Destination_suburb: String
Signature_required: Boolean
Destination_company: String
Destination_country: String
Carrier_service_code: String
Destination_building: String
Sender_details_email: String
Sender_details_phone: String
Destination_post_code: String
Sender_details_company: String
Sender_details_country: String
Destination_delivery_instructions: String

Table Unshipped Orderitems
Value: Number
Width: Number
Height: Number
Length: Number
Weight: Number
Item_id: Integer
Order_id: Integer
Quantity: Integer
Description: String
Tariff_code: String
Stock_on_hand: Integer
Quantity_to_ship: Integer
Country_of_origin: String

Table Unshipped Orderpackages
Name: String
Width: Number
Height: Number
Length: Number
Weight: Number
Order_id: Integer
Package_id: Integer
Packaging_type: String
Tracking_number: String

Table Shipped Orders

Table Shipped Orderitems

Table Shipped Orderpackages

Use SQL on all your SaaS data

Magical SQL for Starshipit with

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Peliqan Ask AI willl write your SQL queries from plain English