I have data warehouse with Fact table Orders, and CustomerDimension, and TimeDimention, and BookDimension.
CREATE TABLE DIM_CUSTOMER( DIMCUSTID NUMBER(6) PRIMARY KEY, CustId NUMBER(4) NOT NULL, L_Name VARCHAR(30) NOT NULL, F_Name VARCHAR(30) NOT NULL, City VARCHAR(20) NOT NULL, Country VARCHAR(20) NOT NULL ) CREATE TABLE TDIM_TIME( TIMEID DATE PRIMARY KEY, DAY NUMBER(2) NOT NULL, MONTH NUMBER(2) NOT NULL, QUARTER NUMBER(2) NOT NULL, SEMESTER NUMBER(2) NOT NULL, YEAR NUMBER(5) NOT NULL ) CREATE TABLE TDIM_BOOK( ISBN NUMBER PRIMARY KEY, TITLE VARCHAR(150) NOT NULL, EDITIONNO NUMBER(2) NOT NULL, PRICE NUMBER(5) NOT NULL, AUTHORS VARCHAR(400) NOT NULL, PUB_NAME VARCHAR(50) NOT NULL, CITY VARCHAR(30) NOT NULL, COUNTRY VARCHAR(30) NOT NULL ) CREATE TABLE TFACT_ORDER( FACTORDERID NUMBER(9) PRIMARY KEY, DIMCUSTID NUMBER(6) NOT NULL, ISBN NUMBER NOT NULL, TIMEID DATE NOT NULL, QUANTITY NUMBER(3) NOT NULL, PRICE NUMBER(6) NOT NULL, CONSTRAINT FK_TDIMBOOK FOREIGN KEY (ISBN) REFERENCES hwu.TDIM_BOOK(ISBN), CONSTRAINT FK_TDIMCUST FOREIGN KEY (DIMCUSTID) REFERENCES hwu.TDIM_CUSTOMER(DIMCUSTID), CONSTRAINT FK_TDIMTIME FOREIGN KEY (TIMEID) REFERENCES hwu.TDIM_TIME(TIMEID) )
I need to find if my Best-Customer (Who had buy the most quantity of Books) had orders a lot of orders with low price (Retail Buyer), or he had order a few orders with high price (Wholesale Buyer).
How can I achieve this in Oracle?
Are you seeking an expert for Google adoword campaigner? Do you need huge client instantly without SEO or if you haven’t experience about SEO and adwords? If yes, this service for you. Are you known how can adwords work? You just think it, if your site are going 1stpage 1st position of your targeted keyword than how many sell youare expect. This is the paid SEO where your website are going 1stpage instantly without any SEO work and get targeted sells within 2/3 hours of start campaign. Google adwords ads are show in Google 1st page 1stposition of your targeted keyword and targeted location also. That’s why you will get your targeted customer instantly and start sells rapidly. It’s guarantee that if you use this service you will get huge amount of extra sell. Important think that every person afraid about anxiety of unknown work. Like if I need to create adwords account in your PC and operate it every day in your PC by me it’s may be inconvenience for you. So this service deference from others. You just give me your website address, your targeted keywords, including/ excluding location, demography and your daily & total budget. After that I will create an ad group and campaign for you. And you just paid and get result instantly from ads. You give me payment just ads amount, SEOClerks 20% fees amount and my operating fess 20% of balance. For example, if you target to expense $ 100 for ads than give me order for $ 150 where $ 30 are SEOClerks fees and another $ 20 is my operating cost. In everyday I will send to you proof of your expense, which cost is cut by adwords visitor click. I will send to you proof each and every day by several screenshot of your campaign. Please can’t give order before contact. Before order I need to analysis your website, keywords and also targeted location customer trends. So please Contact me for a custom offer!
Category: Banner Ads