list all data from Customers table
get dates of First and Last orders placed
SELECT MIN(OrderDate) AS FirstOrder,
MAX(OrderDate) AS LastOrder
a. List all order data (Orders table) placed by Customer ID AROUT or BERGS or BLAUS
WHERE CustomerID IN ('AROUT', 'BERGS', 'BLAUS');
b. Select all data from the Orders table, ordered by OrderDate, oldest date on top, for
Prof. HAN Zheng
Dr. oec. HSG, Dipl. Wirts. Ing.
Chair Professor of Goetz Partner Chair of Innovation and Entrepreneurship, Tongji University (CN)
Visiting Professor, University of
Chinese economy status quo
The China Holding and the Five-Year Plans
What are the key challenges and implications for MNCs?
China`s economic development
Chinas economic catch-up
China now and then
Silk road vs. internatio
Benefits of selling on the web
E-commerce contains many advantages:
Source: Essentials of Entrepre
"Business opportunities are like buses, there's always another one coming."
- Richard Branson, founder of Virgin Enterprises
Before you start a business you need an innovative business idea
What is innovative or
The professionals grasp of the numbers is a measure
of the control he has over the events that the figures represent."
- Harold S. Geneen
Finance is a very important topic for young start-ups not only in
Discovery consists of seeing what everybody has seen
and thinking what nobody has thought."
- Albert Szent-Gyorgi
Entrepreneurship is the result of applying creativity and innovation
to needs and opportunities in the marketpla
Business Opportunity: Is it real and large enough?
The mystery of business opportunities:
Business ideas are like busses, there is always another one
coming (Richard Branson)
I was seldom able to see an opportunity until it had
"An entrepreneur tends to bite off a little more than he can chew
hoping he'll quickly learn how to chew it."
- Roy Ash, Co-founder of Litton Industries
Both existing businesses and new ventures face special challenges
There is only one boss the customer. Customers can
fire everybody in the company simply by spending
their money somewhere else.
- Sam Walton
Questions that lead into todays session:
What is special about marketin
There will come a time when big opportunities will be presented to you,
and youve got to be in a position to take advantage of them.
Sam Walton, founder of Wal-Mart Inc.
A business plan serves as an entrepreneurs road map on t
ECON 101 MIDTERM 1
Chapter 1: What Is Economics?
Chapter 2: The Economic Problem
Chapter 3: Demand and Supply
Chapter 4: Elasticity
Chapter 7: Global Markets in Action
All economic questions arise because we want
more than we can get.